Databases

NAVIGATION

vista

SoIf you're not a PostgreSQL Win32 port dev, and *don't know* what they'reup to as far as Vista, why respond to the Q? why respond "fix ityourself" instead of "ask this guy" or "nobody here will know yet" or"post your query on -ports or -hackers". it's as useful as saying "ht...

1 answers | 1175 bytes |

Multi-Master Async Replication

Hi Guys,I'm looking for a replication solution for multimaster environment, withasynchronous transfer thru sites. I saw pg-replicator, but the project'slast news are from 2001, and the solution runs only on 7.0 and 7.1 versions.I'm using pg 8.1.3 both sides, over linux.Do somebody...

1 answers | 385 bytes |

speeding SQLite on a cross-join over two tables

I have the following two tables and related indexes -- CREATE TABLE IF NT EXISTS pt ( id INTEGER PRIMARY KEY, x REAL, y REAL, attr TEXT ) CREATE INDEX ix_pt_x N pt (x) CREATE INDEX ix_pt_y N pt (y) CREATE TABLE IF NT EXISTS py ( id INTEGER PRIMARY KEY, xmin REAL, ymin REAL, xmax REAL, ymax REAL,...

4 answers | 1460 bytes |

vista

MessageFrom: pgsql-general-owner (AT) postgresql (DOT) org[mailto:pgsql-general-owner (AT) postgresql (DOT) org] Behalf BenSent: 19 September 2006 17:03To: Naz GassiepCc: Tom Lane; Ron Johnson; pgsql-general (AT) postgresql (DOT) orgSubject: Re: [GENERAL] vistaPerhaps many of the core developers...

0 answers | 878 bytes |

Optimistic concurrency control

What are peoples thoughts on implementing optimistic concurrency control inSQLite? way is modify the where clause to compare every column being updated,old value to new value. This makes the SQL cumbersome.Microsoft SQL Server has a column data type named TIMESTAMP/RWVERSIN whichis database-wide...

5 answers | 885 bytes |

Count and list only where count is bigger than 1

Hi list,It is possible to make a count select and only display where count column isbigger than 1 ?My SQL is like thisSELECT distinct cli.bairro, ****( * ) as qtdFRM base.cliente cliGRUP BY cli.cidade, cli.bairroRDER BY 2I noticed that I cannot use "where qtd 1" ok ?What to do ?Regards...

2 answers | 350 bytes |

Nested loops are killing throughput

Postgresql 8.1I've tried turning off nested loops to see what the query planner would choose instead of nested loops. It chose a hash join, and it still had a nested loop in the mix! How can I entice the query planner to use a simpler join scheme? What criteria is used to determine whether...

1 answers | 2532 bytes |

vista

MessageFrom: Martijn van [mailto:kleptog (AT) svana (DOT) org]Sent: 19 September 2006 15:10To: Alban HertroysCc: Dave Page; Naz Gassiep; Tom Lane; Ron Johnson;pgsql-general (AT) postgresql (DOT) orgSubject: Re: [GENERAL] vistaIf Vista is so important, why aren't seeing a rash of installatio...

0 answers | 1279 bytes |

Access to databas from the Internet

19/9/2006 22:41, "Lukasz" <fatmouse (AT) poczta (DOT) fmwrote:Hello,I would like to install a PostgreSQL. I know how to manage the databaseitself, creae databases, user, groups and so on. But I don't know howto allow other users, who are outside LAN to connect to databasethrough Interne...

0 answers | 2453 bytes |

Access to databas from the Internet

Hello Lukasz!You need some port forwarding onto your router/firewall. You have to forwardincoming connections on port 5432 (or the port postmaster is listening on)from IP xxx.xxx.xxx.xxx to IP yyy.yyy.yyy.yyy with the according port. Ifyour router is a Linux machine, take a look into the iptable...

0 answers | 1761 bytes |

Limits of arrays

I found a rather strange but working method to compare the contents of twotables in different databases:select 'otformularfeld' as which, md5(array_to_string(array(select md5(id_pkff||id_formular||id_formfeld||id_bf) from otformularfeldwhere quarant=0 order by id_pkff),''))So...

0 answers | 1244 bytes |

inner join is much faster! is that right?

I was doing the explain thing when I discovered my mistake!The think is that I over simplyfied my examples. instead of searchingfor one ID, I was searching for several ids and I forgot to put aparentesis arround the or like this.I was doing this:select *from file a, file_tag b, tag cwhere a.id_f...

0 answers | 963 bytes |