PostgreSQL > pgsql-performance > September 2002

When a table is created with a primary key it generates a index. Dos the queries on that table use that index automatically? Do I need to reindex that index after insertions?

Shridhar Daithankar wrote: <snip If it's any help, the setup I mentioned before with differnt disks for the data and the WAL files was getting an average of about 72 tps with 200 concurrent users on ...

subscribe -- secure email with gpg http://fortytwo.ch/gpg NOTICE: subkey signature! request key 92082481 from keyserver.kjsl.com

According to ext3 hackers (Stephen Tweedie, Andrew Morton). ext3 data=journal mode is much faster than any of the other mode for workloads which do a lot of syncrhonous i/o. Personally, I have seen ...

Hi everyone, There are PostgreSQL servers around that are handling 2,000 simultaneous client connections (in real life) without problems, but no-one obvious seems to have yet taken the time to do ...