what is going on, I would like to know (especially if it
is virtualized).
Deron
On Thu, Jun 5, 2014 at 12:23 PM, Merlin Moncure wrote:
> On Thu, Jun 5, 2014 at 10:58 AM, Jeff Janes wrote:
> > This sounds like a kernel problem, probably either the zone reclaim
> issue,
> >
. Determine
if it is I/O, CPU, or network. Put all your settings back to the way they
were. If the DB did not change, then look at OS and network.
Deron
On Sep 28, 2012 6:53 AM, "antthelimey" wrote:
> On machine 1 - a table that contains between 12 and 18 million rows
> On machine 2 -
ot; to do the bulk insert
http://www.postgresql.org/docs/9.0/static/sql-copy.html
(or)
Drop the indexes (or triggers), do the inserts and build indexes
and triggers.
Some Hardware suggestions are dependendent on if it is I/O, CPU, or
memory bottleneck.
Deron
On Thu, Mar 29, 2012 at 11:5
sible that a specific index creation does not work efficiently on
that architecture...
http://www.postgresql.org/docs/9.1/static/sql-createindex.html
Deron
On Sat, Jan 28, 2012 at 10:21 AM, Jayashankar K B
wrote:
> Hi,
>
> I downloaded the source code and cross compiled it into a
You can use PREPARE... EXECUTE to "cache" the plan (as well as
parsing). However, I find it unlikely this will would explain the
loss in performance you experienced.
Deron
On Fri, Jan 27, 2012 at 11:36 AM, Carlo Stonebanks
wrote:
> Yes, I did test it - i.e. I ran the functions
