Re: [BUGS] BUG #2208: Low performance on select

2006-01-25 Thread Michael Fuhr
On Wed, Jan 25, 2006 at 12:32:31PM +, Fahri CAKIROGLU wrote: > Consecutive selects from three different tables > causes low performance(about 1500 ms). > Same select count from two tables gives good performance(about 30 ms). This might be due to caching. When you query two tables all of the p

[BUGS] BUG #2208: Low performance on select

2006-01-25 Thread Fahri CAKIROGLU
The following bug has been logged online: Bug reference: 2208 Logged by: Fahri CAKIROGLU Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: windows nt 2000 Description:Low performance on select Details: Consecutive selects from three differen