I have a large table which uses a sequence for column which is defined as the
primary key.
Our systems is a real time data acquisition system, so we have "insert"
statements going through it wrapped inside stored procedure.
Every once in a while I get an inserio error on a violation of a unique
2
end case
Any suggestions on how to formulate either the trigger procedure or a rule
would be greatly appreciated.
Regards,
Benjamin
-Original Message-
From: Allan Kamau [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 3:38 PM
To: Benjamin Krajmalnik
Cc: pgsql-admin@postgresq
Title: Re: [ADMIN] Slony1 or DRBD for replication ?
I am running PostgreSQL 8.1.3 on Windows.
The project itself is a real time data acquisition system, so it cannot be
taken off-line for backups.
I have tried using pg_dump, but discovered that the backup was not a
consistent backup. The ap
/2006 9:09 PMTo:
Benjamin KrajmalnikCc: pgsql-admin@postgresql.orgSubject:
Re: [ADMIN] Howto: Using PITR recovery for standby replication
"Benjamin Krajmalnik" <[EMAIL PROTECTED]> writes:> I
have tried using pg_dump, but discovered that the backup was not a =>
consistent
Title: Re: [ADMIN] slow cursor
Siriam,
I have no clue what it is you are trying to
do, but I have a similar situation. I have a monitoring system which sends
data to our psotgresql database. The system calls a single stored
procedure which performs on-the-fly data aggregation for the p
abase as a
whole.
From: Alvaro Herrera
[mailto:[EMAIL PROTECTED]Sent: Thu 4/20/2006 10:02
PMTo: Benjamin KrajmalnikCc: Tom Lane;
pgsql-admin@postgresql.orgSubject: Re: [ADMIN] Howto: Using PITR
recovery for standby replication
Benjamin Krajmalnik wrote:> The particular table
which wa
t: Re: [ADMIN] Howto: Using PITR
recovery for standby replication
Benjamin Krajmalnik wrote:> I am a newbie, so I
essentially invoked pg_dump from with pgAdmin3,> with the defaults
(including large objects). This is the command> being
issued:> > .C:\Program Files\PostgreSQL\8.1\bi
o why I am experiencing
the contraing violation on the unique primary key.
Regards,
Benjamin
From: Tom Lane
[mailto:[EMAIL PROTECTED]Sent: Thu 4/20/2006 9:09 PMTo:
Benjamin KrajmalnikCc: pgsql-admin@postgresql.orgSubject:
Re: [ADMIN] Howto: Using PITR recovery for standby replication
I have created a parent table and inherited into several
tables to facilitate table partitioning.
I noticed that the inherited tables did not inherit any of
the indices, etc. in their DDL.
Do these need to be created, or are they actually there via
inheritance but only “used” when the par
rows.
From: Chris Hoover
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 26, 2006
2:33 PM
To: Benjamin Krajmalnik
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Tale
partitioning
Each of the partition
tables needs it's own set of indexes. Build them, and see if the
y
[mailto:[EMAIL PROTECTED]Sent: Wed 4/26/2006 4:52
PMTo: Benjamin KrajmalnikCc: Chris Hoover;
pgsql-admin@postgresql.orgSubject: Re: [ADMIN] Table
partitioning
Can we see the output of \d tablename as well as EXPLAIN ANALYZE
of theselect?On Wed, Apr 26, 2006 at 02:48:50PM -0600, Benjamin
Krajma
I am about to take a system from testing into production.
The system is a combination oltp/bi (network monitoring
platform).
We are currently inserting about 1 million rows per day, and
will increase to probably 5 million once it goes into full deployment.
The current test production ser
I was thinking of going Raid 0 to increase the active spindles. But,
come to think about it, if I go to FreeBSD I really do not need to go
that route, since I can use a symlink and, as suggested, move the logs
to another spindle.
I was also wary of the Raid 0 approach - specially since last year I
The stored procedure is a plpgsql function which gets passed parameters
from the monitoring agent.
It then dynamically creates a device record for the monitored device if
one does not yet exist.
Once that is done it creates a test record for the particular test if
one does not exist.
Once that is d
at once. It would be great if we could aggregate an array
in one hot, but in the meantime we’ll do it this way.
From: Scott Marlowe
[mailto:[EMAIL PROTECTED]
Sent: Friday, April 28, 2006 9:24
AM
To: Benjamin Krajmalnik
Cc: Ben K.; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] New
I was looking at the files inside my database and came
across files which have the same OID number as the filename but some had
extensions (in my case .1 and .2).
What are these files? Can they be safely deleted?
In my case, they are quite large (over 1GB each).
Regards,
Benja
Thanks.
That definitely would not have been pretty
J
From: Larry Rosenman
[mailto:[EMAIL PROTECTED]
Sent: Monday, May 08, 2006 2:45 PM
To: Benjamin Krajmalnik;
pgsql-admin@postgresql.org
Subject: RE: [ADMIN] PostgreSQL
8.1.3/Windows
They are the 1GB segments of your
I am running PostgreSQL 8.1.3/Win
Earlier yesterday, it appeared that the server stopped
responding.
I went through the log files and noticed the following type
of entries.
22462 is the filenode for my database. I could not
find what the other two are.
2006-05-24 12:16:3
While checking our server, I noticed quite a few files in
the pg_clog directory.
These files date from today back to the day when I installed
PostgreSQL.
Is there a maintenance task which can be run to purge the
files which are no longer needed?
I assume the majority of them are not need
-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 25, 2006 1:14 PM
To: Benjamin Krajmalnik
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Strange errors in log file
On Thu, 2006-05-25 at 14:00, Benjamin Krajmalnik wrote:
> I am running PostgreSQL 8.1.3/
This is running on an HP DL360, SCSI RAID1, 2GB RAM, running Windows
Server 2003.
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 25, 2006 1:20 PM
To: Benjamin Krajmalnik
Cc: pgsql-admin@postgresql.org
Subject: RE: [ADMIN] Strange errors in log file
Currently running 8.1.3. Will be upgrading shortly.
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 25, 2006 1:44 PM
To: Benjamin Krajmalnik
Cc: pgsql-admin@postgresql.org
Subject: RE: [ADMIN] Strange errors in log file
And the postgresql version
autovacuum is running on all databases.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 25, 2006 2:01 PM
To: Benjamin Krajmalnik
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] pg_clog questions
"Benjamin Krajmalnik" <[EMAIL PROTE
and explicitly added the postgresql service account and
given it full access rights to the directory.
Maybe this will keep it from recurring.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 25, 2006 1:59 PM
To: Benjamin Krajmalnik
Cc: Scott Marlowe; pgsql
Thanks.
I revacumed and now they are gone.
-Original Message-
From: Alvaro Herrera [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 25, 2006 4:40 PM
To: Benjamin Krajmalnik
Cc: Tom Lane; pgsql-admin@postgresql.org; Matthew T. O'Connor
Subject: Re: [ADMIN] pg_clog questions
Ben
PM
To: Benjamin Krajmalnik
Cc: pgsql-admin@postgresql.org; Alvaro Herrera; Matthew T. O'Connor
Subject: Re: [ADMIN] pg_clog questions
"Benjamin Krajmalnik" <[EMAIL PROTECTED]> writes:
>>> While checking our server, I noticed quite a few files in the
pg_clog
>>>
I just migrated to 8.1.4/Win this morning.
Under 8.1.3 I would consistently see messages concerning
problems with the statistics collector thread.
So far, not a single log entry, which is good.
I would like to thank all of the developers for such a great
product, and a seamless upgrad
I recently truncated a partitioned table.
When I look at the statistics for the
table, it shows tuples inserted as zero (which I would expect), but it did not
clear the value for tuples updated and tuples deleted.
Is this the expected behavior? I would
assume that the updated/deleted sta
I am in the process of writing a migration utility to move data from a
SQL Server to PostgreSQL. The original schema contains identity fields.
When converting the schema, I have 2 option - either make them serial
(or bigserisl) columns, with the associated automatic constraint, or
declaring the as
, 2006 11:28 AM
To: Benjamin Krajmalnik
Subject: Re: [ADMIN] General question regarding sequences (Serial
columns)
> If I were to use the former (use Serial/BigSerial), is there a command
> which I can issue to keep PostgreSQL from using the sequence, and
> therefore copying over the original
Sriram,
I do this on monthly tables which have about 30 million rows.
Last time I truncated a partition it took anout 2 milliseconds.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Sriram Dandapani
Sent: Monday, June 19, 2006 12:41 PM
To: Tom Lane
Cc: pg
Siriam,
As I mentioned to you yesterday, I have a partitioned table which gets
over a million inserts per day (routed to the correct partition via
triggers). Each partition holds one month' worth of data, so
approximately 30 million rows. Last time I truncated the oldest
partition took 2 ms.
-
In addition to what Rodrigo said so eloquently
in Portuguese (no fallu prtugues! ), the only issue you will
experience is a performance hit.
It is not a good idea to have 2 separate
database servers running on the same set of drive spindles. I usually deploy
them in different servers. Th
Is there a query which can be issued which will return the size of a
database?
I see that in pgadmin you can get the values on a per table manner.
I have looced at the pg_catalog schema, but to be truthful I cannot
figure out how to get that information.
TIA,
Benjamin
---
I have a very strange situation where all of a sudden my database growth
has increased dramatically.
I made some schema changes, bit these were made to some tables which do
not have the massive insertion rate (a few fields were changed from
varchar to inet data types.
The tables which have the mass
Is there a way to determine the name of an object based on the filenode
number?
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
I am running
PostgreSQL 8.1.4 on windows.
I have a table with
the following structure:
CREATE TABLE
"public"."tblksaura" ( "ksaurasysid" SERIAL, "testtime"
TIMESTAMP WITHOUT TIME ZONE, "lasthouralive" DOUBLE PRECISION[],
"last24hrsalive" DOUBLE PRECISION[], "last7daysalive"
DOUB
eason
>
> On 7/13/06, Benjamin Krajmalnik <[EMAIL PROTECTED]> wrote:
> >
> >
> > I am running PostgreSQL 8.1.4 on windows.
> > I have a table with the following structure:
> >
> > CREATE TABLE "public"."tblksaura" (
> > &quo
This is subsequent to the previous issue which I am expperiencing.
In my monitoring application, I have a few tables which contain few rows
but are constantly pounded with updates.
These tables are growing at very high rates. For example, a table with
less than 4K rows, which when reloaded was ab
t: Sunday, July 23, 2006 11:48 AM
> To: Peter Eisentraut
> Cc: pgsql-admin@postgresql.org; Benjamin Krajmalnik
> Subject: Re: [ADMIN] Unexplained growth of tables
>
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > Benjamin Krajmalnik wrote:
> >> What can be cau
enough to point me in the
right direction.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Benjamin Krajmalnik
> Sent: Sunday, July 23, 2006 2:06 PM
> To: Tom Lane; Peter Eisentraut
> Cc: pgsql-admin@postgresql.org
I am runing PG 8.1.4/Windows.
Over the weekend, I have had to restart the PostgreSQL service a couple
of times after PG hangs.
At the time this happens, the log is showing entries such as the one
below
2006-07-31 09:19:55 LOG: could not rename file
"pg_xlog/0001020800E1" to
"pg_xlog/0
no AV running.
Nothing there to do anything on the
file.
There are only 2 applications running on that box -
PostgreSQL and Apache.
From: Shoaib Mir [mailto:[EMAIL PROTECTED]
Sent: Monday, July 31, 2006 11:58 AMTo: Benjamin
KrajmalnikCc: pgsql-admin@postgresql.orgSubject: Re:
I am building a new FreeBSD 6.1 box to migrate from the
Windows PostgreSQL.
I am having some issues getting PostgreSQL to load when I
try to duplicate my configuration as running on the Windows
box.
I have made the modifications to loader.conf. All of
the SHM values are being set properly
I am currently
running PG 8.1.4 windows.
The system is for a
real time monitoring application (so downtime needs to be minimized if at all
possible).
I will be migratng
to a new server running PG 8.1.4 on FreeBSD 6.1.
I have been playing
with various options for migrating the data. The d
-
From: Joshua D. Drake <[EMAIL PROTECTED]>
To: Benjamin Krajmalnik <[EMAIL PROTECTED]>
CC: pgsql-admin@postgresql.org
Sent: Thu Aug 03 21:01:54 2006
Subject: Re: [ADMIN] File system backup question
Benjamin Krajmalnik wrote:
> I am currently running PG 8.1.4 windows.
>
I am trying to
restore a database from a pg_dump.
I have a problematic
issue in that a few rows have a problem with UTF-8 encoding.
All of these rows
are in a specific table.
Is there something I
can run against the table which will validate the rows which have the bad data
and delete the r
riday, August 04, 2006 1:36 PM
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Restoring dtabase problem
>
> Am Freitag, 4. August 2006 19.06 schrieb Benjamin Krajmalnik:
> > I am trying to restore a database from a pg_dump.
> > I have a problematic issue in that a fe
I have a minor problem with autovacuum.
Below are the logs:
2006-08-06 15:37:08 MDTLOG: autovacuum: processing database "postgres"
2006-08-06 15:37:22 MDTFATAL: database "psotgres" does not exist
2006-08-06 15:37:52 MDTFATAL: database "psotgres" does not exist
2006-08-06 15:38:22 MDTFATAL: dat
Ignore question.
I found the problem. When I launched pgagent, I had a transposition of
the database name.
After I identified thi and restarted pgagent everything looks ok.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Benjami
I just migrated from PG 8.1.4 Windows to 8.1.4 FreeBSD/i386.
All of the data insertion to the database is done via a stored procedure
call.
I did some benchmarking, and on an empty database the execution time of
the stored procedure was about 5 ms on average.
This was done running via EMS SQL Mana
database does not
keep up with it it will stall.
Worst case, I will virtualize the monitroing agent, but that will
require quite a bit of work on our side.
> -Original Message-
> From: Chris Mair [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 07, 2006 2:54 AM
> To: Benjami
a separate spindle, are there any other things
you can think of which may improve the performance?
> -Original Message-
> From: Chris Mair [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 07, 2006 4:38 PM
> To: Benjamin Krajmalnik
> Cc: pgsql-admin@postgresql.org
> S
I have a database whose records are inserted via
ODBC.
I turned on logging, and the client is explicitly setting
the client encoding to UTF.
Rows are inserted into the tables. When I do a
pg_dump, I do not get any errors. When I try tor restore, I am getting an
error regarding an invalid
I have a problem right now where the execution time of a scheduled
stored procedure is creating an issue with our background data logging
system.
Initially I thought it may be caused due to table locks or the like, but
after much testing I have ruled that out, since data is being inserted
while the
I have a database which has UTF8 encoding enabled (why? I am really not
sure why I did tihs other than the source of the data is windows and I
had some issues with characters > ascii 128 being sent across from some
of the Windows event logs).
The problem which I am having is as follows:
The data
.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Benjamin Krajmalnik
> Sent: Thursday, October 05, 2006 12:03 PM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] pg_dump/pg_restore problem
>
> I have a database which has UTF8 e
I have a partitioned
table to which I route data using a trigger.
I am changing it to
use a set of rules which executes "INSTEAD" on insert.
The parent table
currently has a trigger.
The system is a live
system. I would prefer to not have to suspend the data
flow.
If I create the
rules,
I am battling a performance issue and was wondering if someone could
help. PostgreSQL 8.1.5, FreeBSD.
I have a very intense stored procedure which performs real time
aggregation of data.
I captured the stored procedure calls from a production system and
pumped them through psql, logging duration
t connection.
> Better yet, don't make lots of tiny calls to the database if
> you can avoid it.
>
> On Mon, Dec 04, 2006 at 06:28:03PM -0700, Benjamin Krajmalnik wrote:
> > Hi Jim,
> >
> > Apples to apples (as best as I can tell).
> > The test procedu
select CURRENT_TIMESTAMP
or
select LOCALTIMESTAMP
the first has the information with the timezone offset at the end,
whereas the second does not.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Negandhi, Nishith
Sent: Thursda
Aaron,
Would case studies work?
I suggest you mention the Netezza data warehousing appliance - on their
site they have comparisons against other systems which will be
impressive.
Although annecdotal, in my case I had an application running on SQL
Server. It could not keep up with the data throug
http://www.postgresql.org/developer/roadmap
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Abraham, Danny
> Sent: Tuesday, May 08, 2007 8:25 AM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] 8.3 and 8.4 feature list
>
> Hi,
>
> I am migrat
select pg_postmaster_start_time()
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Chris Hoover
Sent: Wednesday, June 06, 2007 3:07 PM
To: pgsql-admin@postgresql.org Admin
Subject: [ADMIN] How to tell how long serve
My Windows box says:
"PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.2 (mingw-special)"
My BSD box says:
"PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.2 (mingw-special)"
Seems to be the same
---(end of broadcast)
D. Drake [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 12, 2007 3:39 PM
> To: Benjamin Krajmalnik
> Cc: Adam Witney; pgsql-admin@postgresql.org; Abraham, Danny
> Subject: Re: [ADMIN] How can I tell that the underlying OS is Windows?
>
> Benjamin Krajmalnik wrote:
> > My Win
PostgreSQL Manager from EMS has one.
I recommend getting their Studio product, which integrates all of their
tools.
Definitely worth the price.
---(end of broadcast)---
TIP 6: explain analyze is your friend
My aplogies - I forgot to set the subject of the problem I am having
when I got lazy and used "reply".
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Benjamin Krajmalnik
> Sent: Wednesday, August 01, 2007 11:32 AM
&g
I have ascheduled pgAgent job which runs monthly executing a stored
procedure which handles some partitoned tables. Essentially, it
truncated the data in a given partitio and then it changes its rules so
it will be ready to accept the data for its respective next cycle.
The stored procedure foll
In case you did not read my message, it started with "My apologies"
becaue I made the mistake and noticed it.
Please, do not try to lecture me. If you have something substanbtive to
reply concerning the issue I am having, then by all means do reply. I
did not know you were the self-proclaimed lis
Is there a way to execute an external program from within a stored
procedure?
In pl/pgsql it does not appear to be supported.
Will pl/perl allow me to do so?
A little background. I have a network monitoring platform which we
developed. The collector has the capability of issuing a single query
fo
Toad Data Modeler
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Marco Antonio
> Sent: Monday, December 17, 2007 2:02 PM
> To: Mark Steben
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Looking for an E/R tool for Postgres
>
> On Dec 17,
You have already posted this various times..
Have you checked with your AV provider that it is not a false positive?
I do not think it is necessary for you to be posting this every day.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Al
I am encountering a very strange client encoding issue.
>From the logs on the server, I am getting the following:
canopy02# tail postgresql-2008-01-16_00.log
2008-01-16 15:20:03 ESTERROR: conversion between latin9 and LATIN1 is
not supported
2008-01-16 15:20:03 ESTSTATEMENT: set client_enco
.
>
> Best regards
> Ivo
>
> Am Mittwoch, 16. Januar 2008 21.30:42 schrieb Benjamin Krajmalnik:
> > I am encountering a very strange client encoding issue.
> > From the logs on the server, I am getting the following:
> >
> > canopy02# tail postgresql-2008-01-
implicitly?
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Benjamin Krajmalnik
> Sent: Wednesday, January 16, 2008 3:45 PM
> To: Ivo Rossacher; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Strange client encoding issue
&g
Another option on Windows would be to get the Sysinternals utilities,
and use tcpview, which is superior to netstat.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Melissa Peterson
Sent: Tuesday, April 01, 2008 10:29 AM
T
Assuming he is using ODBC to connect, I do not believe the current ODBC
driver supports connection pooling.
My experience was that it did not. I posted a question on the ODBC
list, but have not yet received a reply.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTEC
I just migrated from 8.1 to 8.3, running on FreeBSD 7.0 amd64.
Running 8.3.5
I have a query concatenating 3 columns to create a hash.
userid is a numeric(38,0) field, accountno is an integer, and
requestdate is a date.
Under 8.1, Select userid || accountno || requestdate::date as newcolumn
fro
[EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Milen A. Radev
> Sent: Saturday, December 06, 2008 12:49 PM
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Change in behavior of string concat operator
>
> Benjamin Krajmalnik написа:
> > I just migrated from 8.1
Thanks, Stephan and Milen.
Everything is clear now.
I had a change in the behavior moving from 8.1 to 8.3, and the automatic
typecasting prior to 8.3 blurred the intended behavior as per the
documentation.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your s
He must be a card carrying member of the ACLU, and now he thinks he is
the G_d of these lists :)
> -Original Message-
> From: pgsql-admin-ow...@postgresql.org
> [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Joshua D. Drake
> Sent: Monday, February 02, 2009 4:22 PM
> To: Scott Ru
So what if he voices his beliefs.
This PC BS is over the top.
If you are so offended by his by-line, to the extent that you want to
remove yourself fomr the mailing lists, then by all means do so.
I am not a Christian (I am Jewish, so I guess that puts me one rung
below Bruce), and am definitely no
Never mind.
I restarted PostgreSQL and stats are now collecting again.
From: Benjamin Krajmalnik
Sent: Friday, July 03, 2009 3:23 PM
To: pgsql-admin@postgresql.org
Subject: Statistical tracking issue
I am running 8.3.7 on FreeBSD 7.0/amd64.
It appears that at some point about 2 weeks
I am running 8.3.7 on FreeBSD 7.0/amd64.
It appears that at some point about 2 weeks ago statistics tracking
ceased.
I have the following query which I use to track cache hits, and it is
not being updated:
SELECT pg_stat_database.datname, pg_stat_database.blks_read,
pg_stat_database.blks_hit,
I apologize for the slightly off-topic question.
I will be building a new PostgreSQL server running 8.4 on FreeBSD 7.2
64-bit.
The nature of the application dictates that we use shared storage to
provide high availability (in case one of the servers has a failure).
After doing some research in t
PostgreSQL 8.3.7 running on FreeBSD.
The following query:
update tblksalerts
set cleartime = x_cleartime,
laststatusid = x_statusid,
lastreplytext = x_replytxt,
lasttesttime = x_testtime
I tried it with both on and off, and it did not make a difference.
> -Original Message-
> From: Alvaro Herrera [mailto:alvhe...@commandprompt.com]
> Sent: Wednesday, July 29, 2009 3:20 PM
> To: Benjamin Krajmalnik
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN]
e, timestamp
without time zone, integer, character varying, character varying,
integer) OWNER TO postgres;
> -Original Message-
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
> Sent: Wednesday, July 29, 2009 3:31 PM
> To: Alvaro Herrera
> Cc: Benjamin Krajmalnik; pg
e worked around this by setting the variable to a blank string if
the value passed to the stored procedure is a null value, but there
definitely appears to be an issue in there.
> -Original Message-
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
> Sent: Wednesday, July 29, 2009 4:43
consider this closed unless I see it occur again.
Sorry for the false alarm.
> -Original Message-
> From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-
> ow...@postgresql.org] On Behalf Of Benjamin Krajmalnik
> Sent: Wednesday, July 29, 2009 5:00 PM
> To: Tom Lane
>
I recently built a test server running 8.4/FreeBSD 7.2/amd64, built from
the ports.
I am seeing the following message in the logs:
"autovacuum: found orphan table "pg_temp_1""."pga_tmp_zombies" in
database "postgres"
"autovacuum: found orphan table "pg_temp_2""."pga_tmp_zombies" in
databas
I am setting up a test environment to simulate a very high load. We
have a server farm which is receiving data (cold be thousands of
simultaneous users posting data). I currently have max_connections set
to 500 and the server is starting ok. If I try to increase the
max_connections to 1000, the
Yes, I had, but apparently the values were not high enough to
accommodate that many connections.
I retuned the IPC kernel setting, and now it appears to be running fine.
Thanks.
From: Shoaib Mir [mailto:shoaib...@gmail.com]
Sent: Monday, August 10, 2009 11:51 PM
To: Benjamin Krajmalnik
guidance.
As always, thank you so much for your assistance.
> -Original Message-
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
> Sent: Tuesday, August 11, 2009 7:54 AM
> To: Benjamin Krajmalnik
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Max connecti
I am trying to cluster a table for which vacuum full is not reducing its
size.
When I do so, I am getting the following error:
ERROR: missing chunk number 0 for toast value 207869115 in
pg_toast_145099
** Error **
ERROR: missing chunk number 0 for toast value 207869115
": moved 495
row versions, truncated 4479 to 4457 pages
DETAIL: CPU 0.00s/0.02u sec elapsed 0.02 sec.
INFO: index "pg_toast_145099_index" now contains 117973 row versions in
343 pages
DETAIL: 495 index row versions were removed.
0 index pages have been deleted, 0 are curre
Strange - seems to have sorted itself out.
I turned off a scheduled vacuum of the table and within a few minutes I
sorted itself out.
I have reduced the frequency of the vacuuming task which is being
carried out via pgagent.
From: Benjamin Krajmalnik
Sent: Monday, December 14, 2009 12:28
PostgreSQL 8.4/FreeBSD 7.2 amd64
I have a database which has 3 tables which get a very high level of
activity (about 40 thousand updates per minute).
The tables are getting quite bloated, since autovacuum is apparently not
optimally configured (it is using the default settings).
Anything I d
ows; 9832 rows in sample, 48155 estimated total rowsTotal query runtime:
6937 ms.
Any suggestions on how to better tune autovacuum, or alternatively do you
recommend just running a vacuum analyze as a pgagent scheduled task?
> -Original Message-
> From: Scott Marlowe [mailto:scott
1 - 100 of 151 matches
Mail list logo
