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
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
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
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
