Re: [PERFORM] problem with select *

On 08/24/2015 03:04 AM, bhuvan Mitra wrote: Hello, I have a table with 12 columns and 20 Million rows. While writing the table I do not find any problem but when reading that I have some issues faced. When I perform a 'select * from table limit 1400;' (selecting 14million rows), it is w

Re: [PERFORM] problem with select *

På mandag 24. august 2015 kl. 09:04:07, skrev bhuvan Mitra mailto:bhuvan...@gmail.com>>: Hello,   I have a table with 12 columns and 20 Million rows. While writing the table I do not find any problem but when reading that I have some issues faced. When I perform a 'select * from table limit 140

Re: [PERFORM] problem with select *

Hi, Please share with us on the configuration in postgresql.conf Thanks! On 24 August 2015 at 15:04, bhuvan Mitra wrote: > Hello, > > I have a table with 12 columns and 20 Million rows. While writing the > table I do not find any problem but when reading that I have some issues > faced. When I

[PERFORM] problem with select *

Hello, I have a table with 12 columns and 20 Million rows. While writing the table I do not find any problem but when reading that I have some issues faced. When I perform a 'select * from table limit 1400;' (selecting 14million rows), it is working fine. If the limit value is 1500, it is

Re: [PERFORM] problem with select count(*) ..

On Thu, Nov 20, 2003 at 07:07:30 +0530, Rajesh Kumar Mallah <[EMAIL PROTECTED]> wrote: > > If i dump and reload the performance improves and it takes < 1 sec. This > is what i have been doing since the upgrade. But its not a solution. > > The Vacuum full is at the end of a loading batch SQL fil

[PERFORM] problem with select count(*) ..

Ever Since i upgraded to 7.4RC2 i am facing problem with select count(*) . In 7.3 the problem was not there select count(*) from data_bank.profiles used to return almost instantly , but in 7.4 explain analyze SELECT count(*) from data_bank.profiles;