Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT INTO large FKyed table is slow - Mailing list pgsql-performance

From Mladen Gogala
Subject Re: SELECT INTO large FKyed table is slow
Date
Msg-id 4CF686E7.4040207@vmsinfo.com
Whole thread Raw
In response to Re: SELECT INTO large FKyed table is slow  (Kenneth Marshall <ktm@rice.edu>)
List pgsql-performance
Tree view 
Kenneth Marshall wrote:
> Redhat6 comes with ext4 which is an extent based filesystem with
> decent performance.
>
> Ken
>
But e4defrag is still not available. And, of course, Red Hat 6 is still
not available, either.  Maybe Red Hat 7 will do the trick? I assume it
will work beautifully with PostgreSQL 15.0.

--

Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com
The Leader in Integrated Media Intelligence Solutions

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: SELECT INTO large FKyed table is slow
Next
From: Mladen Gogala
Date:
Subject: Re: SELECT INTO large FKyed table is slow