Re: [PERFORM] Help with extracting large volumes of records across related tables

the relationship between PvA and PvB on a row-by-row basis. Have you considered using cursors? -- Paul Thomas +--+---+ | Thomas Micro Systems Limited | Software Solutions for Business | | Computer Consultants | http

Re: [PERFORM] insert

an index but a type mis-match (e.g, an int4 field referencing an int8 field) Either of these will cause a sequential table scan and poor performance. -- Paul Thomas +--+-+ | Thomas Micro Systems Limited | Software Solutions

Re: [PERFORM] The black art of postgresql.conf tweaking

to know: - PostgreSQL version - hardware configuration (SCSI or IDE? RAID level?) - table schemas - queries together with EXPLAIN ANALYZE output also output from utils like vmstat, top etc may be of use. HTH -- Paul Thomas

Re: [PERFORM] Visual Explain

On 17/06/2004 12:10 Adam Witney wrote: Will this run on other platforms? OSX maybe? It's a Java app so it runs on any any platform with a reasonably modern Java VM. -- Paul Thomas +--+-+ | Thomas Micro Systems Limited

Re: [PERFORM] ORDER BY user defined function performance issues

.value1,t1.value2, getday_total(..) AS foo FROM tblitem t1 WHERE t1.type_id=23::int2 and (t1.id = 1::int8 and t1.id=9223372036854775807::int8) ORDER BY foo might work. Otherwise try selecting into a temp table then doing the order by on that table. HTH -- Paul Thomas

Re: [PERFORM] MySQL vs PG TPC-H benchmarks

benchmarks which also show that. -- Paul Thomas +--+-+ | Thomas Micro Systems Limited | Software Solutions for Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk

Re: [PERFORM] MySQL vs PG TPC-H benchmarks

for todays average hardware configuration (1+GHz, 0.5+GB RAM, fast FSB, fast HDD). It seems to me better strategy to force that 1% of users to downgrade cfg. than vice-versa. regards ch This has been discussed many times before. Check the archives. -- Paul Thomas

Re: [PERFORM] PostgreSQL and Linux 2.6 kernel.

I will gladly give you the information. Googling threw up http://spider.tm/apr2004/cstory2.html Interesting and possibly relevant quote: Benchmarks have shown that in certain conditions the anticipatory algorithm is almost 10 times faster than what 2.4 kernel supports. HTH -- Paul Thomas

Re: [PERFORM] select slow?

could be eating up the 13 seconds. Given that the client and server are on different machines, I'm wondering the bulk of the 13 seconds is due a network mis-configuration or a very slow DNS server... -- Paul Thomas

Re: [PERFORM] Scaling further up

, whilst it will probably have a lower seek time than a 10K rpm disk, won't have a proportionately (i.e., 2/3rds) lower seek time. - likelihood of page to be cached in memory by the kernel That's effective cache size. -- Paul Thomas

Re: [PERFORM] Scaling further up

? -- Paul Thomas +--+-+ | Thomas Micro Systems Limited | Software Solutions for the Smaller Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk

Re: [PERFORM] Compile Vs RPMs

) which has still got its rpm binaries. My other machines have all been upgraded from source. -- Paul Thomas +--+-+ | Thomas Micro Systems Limited | Software Solutions for the Smaller Business | | Computer Consultants

Re: [PERFORM] go for a script! / ex: PostgreSQL vs. MySQL

? Something like this, you get the idea. ISR reading that 7.4 will use a default of shared_beffers = 1000 if the machine can support it (most can). This alone should make a big difference in out-of-the-box performance. -- Paul Thomas

Re: [PERFORM] Attempt at work around of int4 query won't touch int8 index ...

.. Interestingly, float8 indexes do work OK (float8col = 99). I spend a large part of yesterday grepping through the sources to try and find out why this should be so. No luck so far but I'm going to keep on trying! -- Paul Thomas

Re: [PERFORM] Tests

/AMD based hardware. /selfish-mode Selfishness and sillyness aside, I'm sure your tests will of interest to us all. Thanks in advance -- Paul Thomas +--+-+ | Thomas Micro Systems Limited | Software Solutions for the Smaller

Re: [PERFORM] How to force PostgreeSQL to work faster?

cause data corruption). Try modifying your program to have connection.setAutoCommit(false) and do a connection.commit() after say every 100 inserts. HTH -- Paul Thomas +--+-+ | Thomas Micro Systems Limited | Software

Re: [PERFORM] Perfomance Tuning

start off with something like shared_buffers = 2000 sort_mem = 1024 max_coonections = 100 and see how it performs under normal business loading. -- Paul Thomas +--+-+ | Thomas Micro Systems Limited | Software Solutions

Re: [PERFORM] index / sequential scan problem

a seq scan for small tables as the whole table can often be bought into memory with one IO whereas reading the index then the table would be 2 IOs. HTH -- Paul Thomas +--+-+ | Thomas Micro Systems Limited | Software

Re: [PERFORM] Pgsql - Red Hat Linux - VS MySQL VS MSSQL

/database/. I'd welcome your oppinions on this product. Thank you for your comments. It looks like they just wrote a number of GUI versions of the command line utilities. From what I can tell, its still a standard postgresql database behind the scenes. -- Paul Thomas