On Fri, Jun 03, 2011 at 07:15:40AM +0200, to...@tuxteam.de wrote:
but you wouldn't have large blobs of data clobbering your regular queries.
You would want to write better queries than
select * from my_table_with_bytea_column;
anyway.
You could pass the scans and pics piecemeal
Greets,
I'm trying to figure out why the following SELECT has become slow (hardware,
code changes, etc) and would appreciate any comments on interpreting the
EXPLAIN ANALYZE output. It *used* to take a few seconds at most, but not
anymore... In figuring out which part is taking so long, what's
I'm running into make problems on MacOSX.
While technically solved, I was wondering if there was a better way.
To cut a the long story short (the gory details are
@ http://stackoverflow.com/questions/6225510/), I'd like to pass the USE_PGXS=1
PGUSER=postgres variables automatically when
Greets,
I'm trying to figure out why the following SELECT has become slow
(hardware,
code changes, etc) and would appreciate any comments on interpreting the
EXPLAIN ANALYZE output. It *used* to take a few seconds at most, but not
anymore... In figuring out which part is taking so long,
On Thu, 2 Jun 2011 08:50:30 +0800, Craig Ringer wrote:
On 1/06/2011 9:06 PM, Michal Politowski wrote:
What may be the cause of this weird problem? Is it some known or unknown bug
in
8.3.4 or is the application/Java side more suspected?
It'd be really helpful if you could collect and
I did some testing involving changing a computer's time, and left the
time one year early (6/3/2010 instead of 2011). The PostgreSQL service
now will not start up. Here's what the log says:
2011-06-03 08:46:50 EDTWARNING: autovacuum not started because of
misconfiguration
2011-06-03
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Craig Ringer
Sent: Donnerstag, 2. Juni 2011 10:53
On 02/06/11 16:26, Szymon Guz wrote:
Hi,
do we need some special configuration for SSD drives, or is that
On 3 June 2011 01:26, David Johnston pol...@yahoo.com wrote:
Hi,
I am trying to get a better understanding of how the following Foreign Keys
with Update Cascades and validation trigger interact. The basic setup is a
permission table where the two permission parts share a common
Michal Politowski mpol...@meep.pl writes:
Thinking aloud: If this is, as it is to be suspected, an application-side
problem,
there is at first sight not much space in the application where it could
hide. The data is
mixed up in a driver buffer, two method calls from the standard library
On Fri, 3 Jun 2011 09:53:59 -0400, Tom Lane wrote:
[...]
You'd probably be better off asking these questions in pgsql-jdbc ...
a lot of us here don't even speak Java.
Good point. Will try the other list. Thank you for your help.
--
Michał Politowski
Talking has been known to lead to
David Johnston pol...@yahoo.com writes:
I am trying to get a better understanding of how the following Foreign Keys
with Update Cascades and validation trigger interact. The basic setup is a
permission table where the two permission parts share a common
group/parent which is embedded into
On Fri, June 3, 2011 13:57, t...@fuzzy.cz wrote:
See this http://explain.depesz.com/s/THh
There's something very wrong with snames - the planner expects 22 rows but
gets 164147851. Which probably causes a bad plan choice or something like
that.
Try to analyze the snames table (and maybe
On 6/3/11 8:52:15 AM, Rob Richardson wrote:
I did some testing involving changing a computer’s time, and left the
time one year early (6/3/2010 instead of 2011). The PostgreSQL service
now will not start up. Here’s what the log says:
2011-06-03 08:46:50 EDTWARNING: autovacuum not started
Bill Moran wmo...@potentialtech.com writes:
On 6/3/11 8:52:15 AM, Rob Richardson wrote:
I did some testing involving changing a computers time, and left the
time one year early (6/3/2010 instead of 2011). The PostgreSQL service
now will not start up. Heres what the log says:
2011-06-03
My thanks for your replies. We used pg_resetxlog to clear things up.
The database was not in active use, so the loss of the transactions
didn't matter.
RobR
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Thanks for the replies, and suggestion from Ognjen, Ben Chobot, John R
Pierce, Tomás, and Karsten... I checked the links, and I decided, that I
cannot decide :-) because I don't know, how large could be the
infrastructure for this. If I store the images, and scanned docus in the
database, a
transaction. No passing connections by hand anywhere, everything should be
nicely thread-bound. Still, if not here, where could it go wrong?
I have seen two cases in my career where there was an evil box on the
network that corrupted the traffic.
The first was a very long time ago (in the
On Fri, June 3, 2011 13:57, t...@fuzzy.cz wrote:
There's something very wrong with snames - the planner expects 22 rows but
gets 164147851. Which probably causes a bad plan choice or something like
that.
Try to analyze the snames table (and maybe increase the statistics
target on the
On Fri, June 3, 2011 13:57, t...@fuzzy.cz wrote:
There's something very wrong with snames - the planner expects 22 rows
but
gets 164147851. Which probably causes a bad plan choice or something
like that.
Try to analyze the snames table (and maybe increase the statistics
target on the
I have an overloaded DB and I see several IDLE connections that are using
significant CPU.. (Not Idle in transaction)
Why would an idle process be eating so much cpu? Or is it not actually idle?
Here is an example from pg_top:
last pid: 11821; load avg: 6.11, 6.32, 7.64; up 1+21:05:31
On Fri, Jun 3, 2011 at 3:15 PM, bubba postgres bubba.postg...@gmail.com wrote:
I have an overloaded DB and I see several IDLE connections that are using
significant CPU.. (Not Idle in transaction)
Why would an idle process be eating so much cpu? Or is it not actually idle?
Because there's
another option is using sqlite for storing images. All data is in single
file. (or files if you organize it that way) easier backup etc... you have
some db benefits and retaining solid speed vs file system. Haven't used
this, but seems as viable option to explore.
Esmin
On Fri, Jun 3, 2011 at
[ For future reference, -general is the appropriate list. Moving
discussion there. ]
On Sat, 2011-06-04 at 00:45 +0300, Alexander Shulgin wrote:
We've noticed that free disk space went down heavily on a system, and
after a short analysis determined that the reason was that postmaster
was
On 06/03/11 3:09 PM, Esmin Gracic wrote:
another option is using sqlite for storing images. All data is in
single file. (or files if you organize it that way) easier backup
etc... you have some db benefits and retaining solid speed vs file
system. Haven't used this, but seems as viable option
24 matches
Mail list logo
