John D. Burger wrote:
I have a good-size DB (some tables approaching 100M rows), with
essentially static data.
Should I always cluster the tables? That is, even if no column jumps
out as being involved in most queries, should I pick a likely one and
cluster on it? (Of course, this assumes
sorry, forgot to mention psql8.1.4 on fedora core 4On 10/6/06, A. Kretschmer [EMAIL PROTECTED]
wrote:amThu, dem 05.10.2006, um 17:45:36 -0300 mailte Hugo folgendes: Hi,
is it possible to check for sqlstate inside a function , something like:loop fetch bla. if sqlstate = '02000' then
Hi all,
I have installed postgresql(8.1.4) data dir on a partition (/data) which rests
on a separate disk from OS disk. The install dir is default (usr/local/pgsql).
Now when i use use pgbench with scaling factor of 1000 it creates a whooping 15
GB database. but i see /var partition used space
ls -l /
maybe /data is a symlink?
On Fri, Oct 06, 2006 at 07:10:12PM +0530, km wrote:
Hi all,
I have installed postgresql(8.1.4) data dir on a partition (/data) which
rests on a separate disk from OS disk. The install dir is default
(usr/local/pgsql).
Now when i use use pgbench with
On Fri, Oct 06, 2006 at 09:38:46AM -0400, Ray Stell wrote:
ls -l /
maybe /data is a symlink?
no /data is the label for separate SCSI disk.
no symlinks !!!
/var resides on /dev/sda, and /data in /dev/sdb
regards,
KM
---(end of broadcast)---
/var resides on /dev/sda, and /data in /dev/sdb
I bet you're running a default installation of postgres which has it's
data in /var.
Check your real data directory by running 'ps auxww|grep post', and see
what's after the '-D' parameter... and then when you figure out that the
startup script is
On Fri, Oct 06, 2006 at 03:57:47PM +0200, Csaba Nagy wrote:
/var resides on /dev/sda, and /data in /dev/sdb
I bet you're running a default installation of postgres which has it's
data in /var.
Check your real data directory by running 'ps auxww|grep post', and see
what's after the '-D'
km wrote:
nope! i have purposefully deselected postgres 7.4 installation at OS install.
then downloaded postgresql sources of 8.1.4 and installed it in
/usr/local/pgsql with data dir as /data/pgdata. later , i have set PGDATA to
/data/pgdata in startup script from contrib/scripts of sources
From what I can tell, PostgreSQL 8.0.3 should support Europe/Moscow as
a timezone input string. However, this doesn't seem to work:
db= INSERT INTO synctimes (time, sreplica, shost, dreplica, dhost, seconds,
pseconds) VALUES ('10-05-2006 18:26:13 Europe/Moscow', 9407, 27362, 18516,
35361,
On Sep 29, 2006, at 10:45 AM, Rick Schumeyer wrote:
I hope pg-general is the correct forum for this question…if not
please let me know the correct location.
I have a pg application that uses tsearch2. I would like to move
this application off my local machine and onto a web host
Maybe you switched full statement logging on in postgresql.conf? This can
result in a considerable amount of logfile data in /var/log/somewhere, often
/var/log/postgresql/ (although 15 GB is really quite a lot).
Regards, Frank.
On Fri, 6 Oct 2006 19:10:12 +0530 km [EMAIL PROTECTED] thought
On Fri, Oct 06, 2006 at 09:10:33AM -0500, Brandon Metcalf wrote:
From what I can tell, PostgreSQL 8.0.3 should support Europe/Moscow as
a timezone input string. However, this doesn't seem to work:
db= INSERT INTO synctimes (time, sreplica, shost, dreplica, dhost,
seconds, pseconds)
am Fri, dem 06.10.2006, um 9:10:33 -0500 mailte Brandon Metcalf folgendes:
From what I can tell, PostgreSQL 8.0.3 should support Europe/Moscow as
a timezone input string. However, this doesn't seem to work:
db= INSERT INTO synctimes (time, sreplica, shost, dreplica, dhost,
seconds,
Have you tried looking in /var to see what's there?
find /var -type f -msize +k
ya looking for files bigger than KB showed only:
/var/lib/rpm/RpmPackages
/var/lib/rpm/Filemd5s
regards,
KM
---(end of broadcast)---
TIP 9: In versions
km [EMAIL PROTECTED] writes:
whats happening ?
Unless you're using tablespaces, the server will definitely not write
anywhere outside its assigned data directory. Are you sure that the
growth in /var is related at all? Maybe something spewing messages
to syslog?
Brandon Metcalf [EMAIL PROTECTED] writes:
From what I can tell, PostgreSQL 8.0.3 should support Europe/Moscow as
a timezone input string.
Sorry, no. That's actually new for 8.2.
regards, tom lane
---(end of broadcast)---
Hi,I get this error when accessing the postgresl database -- any ideas? What should I look at?
I can query all of the other tables in the database, just not the email_queue table. Weird!
Thanks in advance,
Mark# psql --versionpsql (PostgreSQL) 7.3.2
contains support for command-line editing
#
km wrote:
Have you tried looking in /var to see what's there?
find /var -type f -msize +k
ya looking for files bigger than KB showed only:
/var/lib/rpm/RpmPackages
/var/lib/rpm/Filemd5s
1. Try a smaller size and see if you get lots of files at say 5000k.
2. Try something else to
Mark Greenbank wrote:
# psql --version
psql (PostgreSQL) 7.3.2
May I be the first to say GODS ALIVE MAN! WHAT ARE YOU STILL DOING
RUNNING 7.3.2!. Even if you can't upgrade from 7.3, the latest release
is 7.3.15 - that's 13 sets of bug-fixes you're ignoring. There's a
passing chance one of
Hi Richard,Thanks for the reply -- yeah, I know it's and old version but management has been reluctant to update a production database. As for the logs, I looked around an didn't see any. pg_ctl start is not using the -l option for logging and output is redirected to /dev/null :(
Anyway, now I
Mark Greenbank wrote:
Hi,
I get this error when accessing the postgresl database -- any ideas? What
should I look at?
I can query all of the other tables in the database, just not the
email_queue table. Weird!
Thanks in advance,
Mark
# psql --version
psql (PostgreSQL) 7.3.2
contains support
Mark Greenbank [EMAIL PROTECTED] writes:
1) I'm assuming that if I update 7.3.2 to 7.3.15 I can leave the data in place
(that is, without doing a dump/restore) -- is this correct?
Yes--minor releases don't require dump/restore.
2) If I up upgrade to 8.x can just copy the data files or do I
I've enabled logging, having upgraded to 7.3.4 (since that was the simplest yum updated :) and I see the following messages:FATAL: unsupported frontend protocol
LOG: server process (pid 26548) was terminated by signal 11
LOG: terminating any other active server processesFATAL: The database system
Hi Doug,Are there any pointers as to how to fix corrupted data? Is seems like that might be the problem as I'm seeing a zero-length read in the log file (see my previous email).Thanks again,Mark
On 10/6/06, Douglas McNaught [EMAIL PROTECTED] wrote:
Mark Greenbank [EMAIL PROTECTED] writes: 1) I'm
k == kleptog@svana.org writes:
k On Fri, Oct 06, 2006 at 09:10:33AM -0500, Brandon Metcalf wrote:
k From what I can tell, PostgreSQL 8.0.3 should support Europe/Moscow as
k a timezone input string. However, this doesn't seem to work:
k
kdb= INSERT INTO synctimes (time, sreplica,
Mark Greenbank [EMAIL PROTECTED] writes:
[ select count(*) from email_queue leads to ]
LOG: server process (pid 26548) was terminated by signal 11
If this is repeatable then it probably indicates corrupt data on-disk
(which 7.3.2 is mostly lacking any defenses for). The trick is to find
and
You can boot from any rescue CD, mount the partition, copy the database
directory away and then copy it back once you have reinstalled. This is
safe because it is on the same machine. It is not safe to copy the
database to some arbitrary computer and expect it to run.
That is basically the
Brandon Metcalf [EMAIL PROTECTED] writes:
k == kleptog@svana.org writes:
k 8.0 only supports such timezones in the form:
k '10-05-2006 18:26:13' AT TIME ZONE 'Europe/Moscow';
That doesn't work, either.
I think AT TIME ZONE was updated to allow long-form tz names in 8.1.
In 8.0 you probably
Brian J. Erickson wrote:
You can boot from any rescue CD, mount the partition, copy the database
directory away and then copy it back once you have reinstalled. This is
safe because it is on the same machine. It is not safe to copy the
database to some arbitrary computer and expect it to run.
Richard Huxton wrote:
Should I always cluster the tables? That is, even if no column
jumps out as being involved in most queries, should I pick a
likely one and cluster on it?
Well you cluster on an index, and if you don't think the index is
useful, I'd drop it. If you have an index,
When I issue a fairly large DELETE query which has multiple tables
with FOREIGN KEY CASCADE on them, Postgres eats up *all* the
memory on my system and the system crashes. I figure that there are
two problems, one is PG eating up all of the memory, the other is the
system crashing and not
On Fri, 2006-10-06 at 11:20 -0400, Mark Greenbank wrote:
Hi Richard,
Thanks for the reply -- yeah, I know it's and old version but
management has been reluctant to update a production database.
If there exists a patchlevel (the third component of the version) higher
than the one you're
Worky Workerson [EMAIL PROTECTED] writes:
When I issue a fairly large DELETE query which has multiple tables
with FOREIGN KEY CASCADE on them, Postgres eats up *all* the
memory on my system and the system crashes.
Well, the memory eating is easy to explain: pending-trigger-event list.
Mabye I made myself not clear enough- sorry for that...
What I want is having a statement like:
PROCEDURE MyProcedure(Value1 int, Value2 text, Value3 varchar(30))
BEGIN
---check if something is valid
---compute something
---store values I got via THIS query and put them in table A, B and
Hello!
I'm using PgSQL for a 3 years for web applications, but not only. But
the main problem is in encoding. My web applications are used by
international (mostly 3 languages: latvian (LATIN7), english and
russian). The best (mostly) solution is to use UTF-8, but there are a
lot of
Our Opteron DB server had a problem with its RAID controller requiring
an immediate shutdown of our Postgres server (8.1.3 on FreeBSD 6.0
release number 10). We used kill -QUIT on the postmaster PID.
After repairing and rebooting the server we tried to start Postgres and
get the following:
Hi,
I would to know if there is some libraries with general algorithm for
Optimum search.
Exemple: I have some function
res := error_estimate(x real, y real, z real, t real)
I wrote a function that
set of res := iterate(nb_iteration, start_x real, step_x real,
that return a
res :=
Hi Devrim,
Thanks for your prompt and accurate reply.
It seems it worked for me.
Thanks and regards,
-Original Message-
From: devrim (at) commandprompt (dot) com
To: Hugo Kawamorita de Souza
Cc: pgadmin-support@postgresql.org
Sent: Fri, 6 Oct 2006 3:32 AM
Subject: Re:
Why would I set a bytea column (containing picures) as a primary key? Because I want to be sure that the same image is inserted only once (that requirement comes from a real project) and using a primary key for that purpose makes sense to me. Am I going to retrieve an image row by its image data?
Hi all, hi Hendrick,
Just a note on this.
I was trying to install pgadmin3-1.4.3-1.i686.rpm on CentOS 4.4 with
PostgreSQL 8.1.4, but I could not install the PgAdmin3 1.4.3 because it
requires the /usr/lib/libpq.so.3.
I tried to do the symbolic link and for my surprise it did not work, it
On Oct 6, 2006, at 11:12 AM, John D. Burger wrote:
Richard Huxton wrote:
Should I always cluster the tables? That is, even if no column
jumps out as being involved in most queries, should I pick a
likely one and cluster on it?
Well you cluster on an index, and if you don't think the
On 10/6/06, Tom Lane [EMAIL PROTECTED] wrote:
Worky Workerson [EMAIL PROTECTED] writes:
When I issue a fairly large DELETE query which has multiple tables
with FOREIGN KEY CASCADE on them, Postgres eats up *all* the
memory on my system and the system crashes.
Well, the memory eating is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/05/06 18:54, Jean-Christophe Roux wrote:
Why would I set a bytea column (containing picures) as a primary
key? Because I want to be sure that the same image is inserted
only once (that requirement comes from a real project) and using
a
Worky Workerson [EMAIL PROTECTED] writes:
On 10/6/06, Tom Lane [EMAIL PROTECTED] wrote:
Well, the memory eating is easy to explain: pending-trigger-event list.
Is there any way to tune PG to execute such a query, or am I forced to
forgo the convenience of the ON DELETE CASCADE and manually
If I subtract 2 timestamps, how do I get the results returned as the total number of minutes.examplenow() - (now()-'2 hours'::interval) = 2:00:00 -- I need the result returned as 120 minutes.Thanks,
Chris
On 10/5/06, Jean-Christophe Roux [EMAIL PROTECTED] wrote:
Why would I set a bytea column (containing picures) as a primary key?
Because I want to be sure that the same image is inserted only once (that
requirement comes from a real project) and using a primary key for that
purpose makes sense
andy rost [EMAIL PROTECTED] writes:
Our Opteron DB server had a problem with its RAID controller requiring
an immediate shutdown of our Postgres server (8.1.3 on FreeBSD 6.0
release number 10). We used kill -QUIT on the postmaster PID.
2006-10-06 12:32:40 CDT PANIC: heap_clean_redo: no
Note that whether you have CASCADE or not is not the issue --- if you
are doing a delete in a foreign-key-referenced relation at all, you
are going to have a trigger event per deleted row no matter what the
details of the FK are.
So the best/fastest* way to do this would be to remove the FK
you could store the pkey as a md5 or sha1
of the image's data. or any of the other large hashing algorithms.
that way your index only has to compare 32 or 40 bytes instead of kilobytes per
row.
as for the main color, you could generate histogram-like
columns (or even a single column)
Hi all,
Iam using postgresql 8.1.4 with 8GB physical RAM.
OS kernel max shared memory usage is set to( /proc/sys/kernel/shmmax) 33554432
dont know if this number is in bytes or bits
now how do i set my shared_buffer setting in postgresql.conf such that ican use
max shared memory setting of the
Am I right in thinking that altering a column from varchar(n) to
varchar(n+m) requires each tuple to be visited?
Recent experience suggests this is the case but my reading of the docs
has left me uncertain why this should be so. We are not changing the
fundamental type of the column, nor are we
select extract(epoch from interval '2 hours')/60;
'epoch' returns the number epoch seconds that comprise the interval.
That differs from 'seconds' which just returns the seconds place,
which is zero for 2:00:00 of course.
-Casey
On Oct 6, 2006, at 12:22 PM, Chris Hoover wrote:
If I
Marc Munro [EMAIL PROTECTED] writes:
Am I right in thinking that altering a column from varchar(n) to
varchar(n+m) requires each tuple to be visited?
Yes. Doing otherwise would require an unreasonable amount of
data-type-specific knowledge hardwired into ALTER COLUMN TYPE.
Hate to suggest corporate software, but there is an Informix/Illustra blade
that could do something like what you're after (I remember a demo of
sunset/sunrise photos being selected on the basis of color values) ...
But I think they used smart blobs and didn't use them as key values.
G
Is there any good documentation, example, tutorial, pamphlet, discussion... to
exploit pg features to obtain polymorphic behavior without renouncing to
referential integrity?
Inheritance seems *just* promising.
Any methodical a approach to the problem in pg context?
--
Ivan Sergio Borgonovo
Hi again, thanks for your guidance, this is the error I got trying to save my fuction:ERROR: unrecognized exception condition no_dataCONTEXT: compile of PL/pgSQL function fn_verificar_aportes_socio near line 36
the symbol is correct , i checked it in the appendix A postgres error codes and
Hugo [EMAIL PROTECTED] writes:
Hi again, thanks for your guidance, this is the error I got trying to save
my fuction:
ERROR: unrecognized exception condition no_data
CONTEXT: compile of PL/pgSQL function fn_verificar_aportes_socio near
line 36
NO_DATA isn't an error condition, only a
Is there any good documentation, example, tutorial, pamphlet, discussion...
to exploit pg
features to obtain polymorphic behavior without renouncing to referential
integrity?
Inheritance seems *just* promising.
Any methodical a approach to the problem in pg context?
I don't know if
Hi Km,
The shmmax setting is in bits.
For knowing the details about the shared_buffer settings and otherconfiguration features follow the link given below:
http://www.powerpostgresql.com/PerfList
The shmmax value set in your kernel (i.e 33554432) seems quite low seeng that you have 8GB
Hi Km,
The shmmax setting is in *BYTES*.
Regards
Talha Khan
On 10/6/06, Talha Khan [EMAIL PROTECTED] wrote:
Hi Km,
The shmmax setting is in bits.
For knowing the details about the shared_buffer settings and otherconfiguration features follow the link given below:
60 matches
Mail list logo
