On Sun, Nov 25, 2018 at 03:37:46PM +0200, Mariel Cherkassky wrote:
> I run it from inside the machine on the local database.
> For example :
>
> db=# create table rule_test as select generate_series(1,1);
> SELECT 1
> db=# explain analyze select generate_series from rule_test orde
I run it from inside the machine on the local database.
For example :
db=# create table rule_test as select generate_series(1,1);
SELECT 1
db=# explain analyze select generate_series from rule_test order by
generate_series asc;
Cc: pgsql-performance@lists.postgresql.org,
pgsql-ad...@lists.postgresql.org
Please avoid simultaneously sending the same question to multiple lists.
It means that people can't see each others replies and everything that implies.
On Sun, Nov 25, 2018 at 03:08:33PM +0200, Mariel Cherkassk
Hi,
I'm using postgres 9.6.
I have a table with 100M+ records which consume on disk about 8GB. In
addition I have an index on the id column of the table.
When I run in psql : explain analyze select id from my_table order by id
The query returns output after 130 seconds which is great. The plan that