Hi,
On Thu, 2010-09-02 at 13:22 -0400, Tom Lane wrote:
> Devrim, have you identified yet which tables have the bloat? Are they
> the ones with tweaked autovacuum parameters?
That's it.
On prod server, that table consumes 50 GB disk space, and on the backup
machine, it uses 148 GB. I applied cu
Hi, I am tryng to compile a C extension in windows using Minigw but always I
get the same error
C:\Program Files\PostgreSQL\8.3\share\exte_c>C:\mingw\bin\gcc -shared -o pg2.dll
pg2.o
pg2.o:pg2.c:(.text+0x86): undefined reference to `_imp__CurrentMemoryContext'
pg2.o:pg2.c:(.text+0x92): undefine
On 2/09/2010 11:59 PM, Bayless Kirtley wrote:
Thanks a lot Craig. The register is connecting through localhost so it's
not that. I
guess I'm not surprised about the Windows thing. I suppose we'll just
have to
live with it then.
I wouldn't be too sure yet.
Did you run the test where you reboot
> Ouch. Are you running Slony by any chance?
Nope, just a stock install. Both servers are running CentOS.
> Do you have *any* idea what caused this?
Nothing definitive unfortunately. Looking back through SVN logs for
code updates there was mention of disabling triggers to perform a
large delete
>The only difference from the database point of view, is that PCs
transactions, since they are much more complex, usually start with a
ROLLBACK (arguable, it will be eventually removed) and for devices they
usually just start with a COMMIT.
Correction ... and for devices they usually just start wi
Eduardo Piombino writes:
> Do you have any idea on what could be causing a SELECT NOW() to never come
> back?
That's truly bizarre. Can you attach to one of these stuck processes
with a debugger and get a stack trace?
regards, tom lane
--
Sent via pgsql-general mailing
Hello list, I'm having a problem with a production system.
I have an application that runs 7x24. It is multithreaded, and every thread
has its own connection to the database.
We have two types of devices connected to each thread, human operated PCs
for billing purposes, and rabbit microcontrollers
On Thu, Sep 2, 2010 at 10:45 AM, Tom Lane wrote:
> Thom Brown writes:
>> I've asked this question on IRC, but unfortunately no answer. Could
>> someone tell me what system catalog changes were made between 9.0
>> beta4 and RC1?
>
> The CVS (or soon to be git) log for catversion.h is a good place
On Thu, Sep 2, 2010 at 5:25 PM, Scott Marlowe wrote:
> On Thu, Sep 2, 2010 at 8:14 AM, Georgi Ivanov
> wrote:
>> Hi,
>> I have some strange problems with my server.
>>
>> Randomly the server gets overloaded with queries.
>> Queries are accepted and never executed, thus reaching max_connections
Alvaro Herrera writes:
> Excerpts from Devrim GÃNDÃZ's message of mié sep 01 17:39:55 -0400 2010:
>> On Wed, 2010-09-01 at 17:32 -0400, Tom Lane wrote:
>>> But are you sure there aren't some fillfactor tweaks in there too?
>>
>> I'm sure. fillfactor related changes are on the radar, but I did
On 2 September 2010 17:45, Tom Lane wrote:
> Thom Brown writes:
>> I've asked this question on IRC, but unfortunately no answer. Could
>> someone tell me what system catalog changes were made between 9.0
>> beta4 and RC1?
>
> The CVS (or soon to be git) log for catversion.h is a good place to
>
Excerpts from Devrim GÜNDÜZ's message of mié sep 01 17:39:55 -0400 2010:
> On Wed, 2010-09-01 at 17:32 -0400, Tom Lane wrote:
> > But are you sure there aren't some fillfactor tweaks in there too?
>
> I'm sure. fillfactor related changes are on the radar, but I did not
> commit them yet...
Maybe
Thom Brown writes:
> I've asked this question on IRC, but unfortunately no answer. Could
> someone tell me what system catalog changes were made between 9.0
> beta4 and RC1?
The CVS (or soon to be git) log for catversion.h is a good place to
look for answers to such questions.
http://anoncvs.pos
Thanks a lot Craig. The register is connecting through localhost so it's not
that. I
guess I'm not surprised about the Windows thing. I suppose we'll just have
to
live with it then. Fortunately it doesn't happen too often. But as fate
would have it,
most often seems when several customers are st
I've asked this question on IRC, but unfortunately no answer. Could
someone tell me what system catalog changes were made between 9.0
beta4 and RC1?
Thanks
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
--
Sent via pgsql-general mailing list (pgsql
On Thu, Sep 2, 2010 at 8:14 AM, Georgi Ivanov wrote:
> Hi,
> I have some strange problems with my server.
>
> Randomly the server gets overloaded with queries.
> Queries are accepted and never executed, thus reaching max_connections limit
> .
> This I/O wait in top command reaches up to 90%
> Cou
Am 02.09.2010 16:32, schrieb Vick Khera:
On Thu, Sep 2, 2010 at 8:16 AM, Joachim Worringen
wrote:
Would the consistency of the database be affected if all indices are
suddenly gone?
The unique constraint is implemented as a unique index. So I'd say
"yeah, you could break your consistency".
On Thu, Sep 2, 2010 at 8:16 AM, Joachim Worringen
wrote:
> Would the consistency of the database be affected if all indices are
> suddenly gone?
The unique constraint is implemented as a unique index. So I'd say
"yeah, you could break your consistency".
Why not purchase a robust RAM/SSD disk sys
Dan Herbert writes:
> select reltriggers from pg_class where relname='users';
>> Development db: 80
>> Live db: 2
Ouch. Are you running Slony by any chance? It's known to fool around
with reltriggers and sometimes mess it up. However, if you're not
getting constant bleats like
too many
Hi,
I have some strange problems with my server.
Randomly the server gets overloaded with queries.
Queries are accepted and never executed, thus reaching max_connections limit
.
This I/O wait in top command reaches up to 90%
Couple of restarts (and sometimes vacuum and reindex of my biggest table
Gerhard Wiesinger writes:
> Did someone fix the double iteration in the buffer cache code as discussed
> at in the meantime:
> http://www.mail-archive.com/pgsql-general@postgresql.org/msg137230.html
No, because you failed to convince anybody there was anything wrong...
r
Good morning,
Hoping someone is able to help me here...
Had a strange issue in a production db this morning: records existed
in one table with a foreign key value which didn't exist in another
table.
TL;DR - many triggers for constraints (and more?) are gone; can they
be recreated easily?
For r
Greetings,
we are setting up a new database server with quite some disks for our
inhouse Postgresql-based "data warehouse".
We are considering to use separate sets of disks for indices (index
space on SSDs in this case) and a table space for tables which are used
as temporary tables (but for
Peter Geoghegan writes:
> On 31 August 2010 18:02, akp geek wrote:
>> Hi all -
>> Is there a way I can tell table - sequence dependent information.
>> which sequences are being used by which table?
>> thanks for the help
>
> Take a look at the post "Finding orphaned sequences" on this b
No ideas on this one?
Regards,
On Tue, Aug 31, 2010 at 04:50:09PM +0200, Henk van Lingen wrote:
>
> Hi,
>
> I've the problem my database is not using the 'right' queryplan in all
> cases. Is there a way I can force that and/or how should I tuned the
> table statistics?
>
> I'
25 matches
Mail list logo
