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 other configuration features follow the link given below:
http://www.powerpostg
Hi Km,
The shmmax setting is in bits.
For knowing the details about the shared_buffer settings and other configuration 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 phy
> 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 k
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, on
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
the symbol is correct , i checked it in the appendix A postgres error codes and co
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
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
-Or
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.
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 subt
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 a
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
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
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
rela
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: n
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
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
"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
-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 pr
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 ea
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 ind
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
comp
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? I
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: [pgadmin-suppor
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 := ROW(b
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:
2
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 problems.
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
"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 lis
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 u
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 te
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, clu
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
"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
> > 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 basica
"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
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> >
k> > db=> INSERT INTO synctimes (time, srep
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'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 syst
"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
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
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 have
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
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 find
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
# psq
"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)--
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?
rega
> 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
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,
> second
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)
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 l
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
somew
>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, 1
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 and
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 '
> /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 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)--
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
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
sorry, forgot to mention psql8.1.4 on fedora core 4On 10/6/06, A. Kretschmer <[EMAIL PROTECTED]
> wrote:am Thu, 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.> i
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 t
60 matches
Mail list logo
