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: [email protected],
[email protected]
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
