On 7/22/13 5:06 AM, Jan-Peter Seifert wrote:
Gesendet: Sonntag, 21. Juli 2013 um 16:03 Uhr
Von: Peter Eisentraut pete...@gmx.net
On Mon, 2013-07-15 at 16:55 +0200, Jan-Peter Seifert wrote:
it seems ( for quite some time now ) that PostgreSQL is using the -c
option of iconv when exporting
On Sun, 2013-07-07 at 10:11 +0200, Thorsten Kampe wrote:
is it possible to start psql in interactive mode without connecting to
a database (similar to sqlplus /nolog for Oracle databases)?
No, that's not possible.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make
On 6/6/13 8:01 PM, Kasia Tuszynska wrote:
dpkg: error processing
/var/cache/apt/archives/postgresql-9.0_9.0.13-1.pgdg10.4+1_amd64.deb
(--unpack):
trying to overwrite '/usr/share/locale/zh_TW/LC_MESSAGES/plpython-9.0.mo',
which is also in package postgresql-plpython-9.0 0:9.0.5-1~lucid
On tor, 2012-04-19 at 10:02 +0200, Albe Laurenz wrote:
After looking at the UNICODE character list I tend to agree that
code point 0xB5 (MICRO SIGN) should not be converted to
0x39C (GREEK CAPITAL LETTER MU). There's 0x3BC for GREEK SMALL LETTER MU.
On ons, 2012-02-29 at 16:25 -0500, Ray Stell wrote:
On Wed, Feb 29, 2012 at 03:55:13PM -0500, Ray Stell wrote:
http://www.postgresql.org/docs/9.1/static/release-9-1-2.html
This must be repeated in each
database to be fixed.
including postgres, template0, and template1?
Yes, if you want
On lör, 2011-12-31 at 17:06 -0800, Jeff Rule wrote:
Does the postgres server support listening on unix domain sockets on windows?
No.
It seems to me that they do not, but this is not called out directly in the
documentation.
Listen_address in postgresql.conf
listen_addresses = ''
On tor, 2011-10-20 at 14:16 -0400, Mark Steben wrote:
Hi all,
I'm evaluating the check_postgres program. We are running postgres
8.3.
Does anybody have any experience with this monitoring software they
would
like to share? I'm specifically interested in the 'postgres_bloat'
program but
On sön, 2011-09-18 at 14:56 +0800, Rural Hunter wrote:
This is my env:
postgres@backup:~$ env
MANPATH=:/opt/PostgreSQL/9.1/share/man
SHELL=/bin/bash
TERM=linux
USER=postgres
LD_LIBRARY_PATH=/opt/PostgreSQL/9.1/lib/
PGPORT=3500
9月18日 21:58:17,Peter Eisentraut写到:
On sön, 2011-09-18 at 14:56 +0800, Rural Hunter wrote:
This is my env:
postgres@backup:~$ env
MANPATH=:/opt/PostgreSQL/9.1/share/man
SHELL=/bin/bash
TERM=linux
USER=postgres
LD_LIBRARY_PATH=/opt/PostgreSQL/9.1/lib/
PGPORT=3500
LS_COLORS=rs=0:di
On mån, 2011-02-14 at 14:18 +0100, Bernhard Schrader wrote:
As far as I read right now, LC_COLLATE is a read_only variable which
is used while initdb. But why does the pg_upgrade script doesn't see
that utf8 and UTF-8 are the same? Is it just a string compare?
Why don't you just reinitialize
On fre, 2010-12-10 at 10:01 -0800, Wells Oliver wrote:
Hello- a quick question about logging. I'm trying to set logging to the
most minimal level possible. e.g. I really don't want to see the
following kind of thing:
2010-12-10 09:59:40 PST FATAL: database woliver does not exist
On mån, 2010-12-06 at 00:29 +0200, Imre Oolberg wrote:
4. compile
$ make
...
gcc -O2 -Wall -Wmissing-prototypes ...
...
postmaster/postmaster.o: In function `PostmasterMain':
postmaster.c:(.text+0x420c): undefined reference to `optreset'
tcop/postgres.o: In function
On tor, 2010-09-23 at 20:55 -0700, Evan Rempel wrote:
I am running Postgresql 8.3 and would like to get postgres to
NOT wrap the syslog lines. Is ther any configuration to do this.
Perhaps I can wrap them at a very large line number?
PostgreSQL 8.4 increased the line length.
--
Sent via
On tis, 2010-02-02 at 17:28 +0200, Achilleas Mantzios wrote:
It seems that libc's behaviour regarding LC_COLLATE in Linux/FreeBSD
are two different stories, hence the seen results.
The UTF-8 locales on FreeBSD and Mac OS X are pretty much broken.
This is becoming a FAQ ...
--
Sent via
On ons, 2010-02-03 at 17:05 +0200, Achilleas Mantzios wrote:
Στις Wednesday 03 February 2010 16:53:20 ο/η Peter Eisentraut έγραψε:
On tis, 2010-02-02 at 17:28 +0200, Achilleas Mantzios wrote:
It seems that libc's behaviour regarding LC_COLLATE in Linux/FreeBSD
are two different stories
On lör, 2009-09-26 at 12:19 -0400, Tom Lane wrote:
Peter Eisentraut pete...@gmx.net writes:
strace on the backend processes all showed them waiting at
futex(0x7f1ee5e21c90, FUTEX_WAIT_PRIVATE, 2, NULL
Notably, the first argument was the same for all of them.
Probably means
On tor, 2009-11-12 at 10:45 -0500, Tom Lane wrote:
In practice the code path isn't sufficiently used or critical
enough to be worth trying to make that bulletproof.
Well, the subject line is recovery is stuck. Not critical enough?
--
Sent via pgsql-admin mailing list
On Wed, 2009-09-23 at 10:04 -0400, Tom Lane wrote:
I'd prefer not to go there, at least not without a demonstration that
this will solve a bug that's unsolvable otherwise. If a child is
really stuck in a state that doesn't accept SIGQUIT, it probably
won't accept SIGKILL either (eg,
I have observed the following situation a few times now (weeks or months
apart), most recently with 8.3.7. Some postgres child process crashes.
The postmaster notices and sends SIGQUIT to all other children. Once
all other children have exited, it would enter recovery. But for some
reason, some
On Wednesday 22 July 2009 08:25:36 Deepak Bala wrote:
Hi everyone,
I have some queries regarding the PITR backup procedure on Postgres
8.3. Here are the steps I follow for backup
1. I set up WAL archiving and checked that this is working.
2. Execute SELECT pg_start_backup('label')
3. Zip
On Saturday 04 July 2009 20:44:11 Ransika de Silva wrote:
I have a requirement of storing multilingual words and hence planing to
utilize the Unicode support of the database tables. The question that I
have is, will there be a problem if I make the primary key of a table
multilingual,
Not
On Friday 22 May 2009 06:51:42 Cliff Pratt wrote:
I've browsed my history of the list, and the Internet for information
regarding giving the unix 'postgres' user a shell of /bin/false, so
that it cannot be logged into directly. It seems from my research that
if I set the user's shell to
On Wednesday 20 May 2009 23:51:53 Arnold, Sandra wrote:
One of my security controls is to audit events. I don't have a problem
on how to do that. However, another control is for all functionality of
the PostgreSQL database to cease or stall if the directory that contains
the audit logs is
On Sunday 22 March 2009 06:26:02 Caleb Cushing wrote:
COPY blarg (blah, bleh, blerg) FROM stdin;
1 random character data
djfa;djjf;sdjl;afkjeoiuoiejk,cxjueiojiojeef98hkjdyf98y92hvniay8syfkdnf38932
hrhf9e83uifnskjj3h9r83hhjnnn2iyfhkjsndfi7y938hnksu879hf089h3n299ssdjfh92
3
the above
samana srikanth wrote:
Can we do a point-in-time restore of a single database out of n
databases??.
In principle no. But you could invent workarounds such as recovering to
the point where you are happy with your restored one database, and then
restore the other n-1 databases from an
Bhujbal, Santosh wrote:
Hi All,
We were getting the following error on executing a COPY command on
postgres8.2.0.
SQL execution failed, Internal error. SQL Statement: (COPY command failed with
error: ERROR: row is too big: size 8200, maximum size 8136)
So, in order to fix the error we
Subbiah Stalin-XCGF84 wrote:
The following is the message we had got while setting up postgres
database. This message was overlooked when we setup but now we have
found the discrepancies. For now the database are created with encode
type as UTF8 but the locale settings are ISO8859-1 in
Gerd König wrote:
a few months ago we started using Postgres on Opensuse10.3-64bit.
We installed Postgres 8.3.1 with the (at that time) latest available rpm's.
But now Postgres' current version is 8.3.4 and I'm wondering why there
are no new rpm's for Opensuse ?!?!
The answer is quite simply
Dave Page wrote:
2008/9/23 Peter Eisentraut [EMAIL PROTECTED]:
Gerd König wrote:
a few months ago we started using Postgres on Opensuse10.3-64bit.
We installed Postgres 8.3.1 with the (at that time) latest available
rpm's.
But now Postgres' current version is 8.3.4 and I'm wondering why
Devrim GÜNDÜZ wrote:
On Tue, 2008-09-23 at 09:49 +0100, Simon Riggs wrote:
I'll look at doing that. We need the SUSE builds also.
I actually built 8.3.4 on SLES 10.2 on..err..Friday, while building
Fedora/RH RPMs. 8.3.1 spec of SLES is broken IMHO, and it requires
special attention from
[EMAIL PROTECTED] wrote:
Well - I did setup two instances of 8.3.3 on an Ubuntu 7.10 system last week - both under a different user account. I
set the locale for each account in the .bashrcs (export LANG=de_DE and export LANG=de_DE.UTF-8
respectively). After that I ran initdb (initdb
Jan-Peter Seifert wrote:
I'm wondering if there's a compatibility list of the tools supplied with
PostgreSQL - e.g. psql seems to be very server version specific (only major or
also minor versions?).
For pg_dump I'd say users should use the version of the target server if it's
already
Jan-Peter Seifert wrote:
we have a mix of older software still using LATIN1 as db encoding and the
psqlODBC-drivers (ANSI) and newer software using UTF8 as db encoding. As
running two server instances would use up more resources(?) than just one we'd
like to have all dbs in one cluster. Which
Am Dienstag, 15. Juli 2008 schrieb Carol Walter:
I have some databases that use SQL ASCII or Latin1 encoding that need
to be UTF8. When I have drop the database and recreated it with the
correct encoding I get errors in restoring the data. How is this done?
What is your PostgreSQL version?
Am Montag, 16. Juni 2008 schrieb Suresh Gupta VG:
Can any one explain me what is the difference between logical link and
foreign key link between the tables in postgresql.
PostgreSQL has no concept by the name of logical link. What are you refering
to?
--
Sent via pgsql-admin mailing list
Am Dienstag, 3. Juni 2008 schrieb Hyatt, Gordon:
http://www.postgresql.org/docs/8.3/static/uuid-ossp.html
My bad - just realised the OP most probably needs a Windows-compatible
solution and uuid-ossp is not.
Actually, I'm developing on Windows, but deploying on Linux (both the
Marc Fromm wrote:
When I restore from a pg_dumpall file, I am required to peform the
following steps or else all the records in the databses are duplicated. If
I only empty the data/base folder I get al sorts of errors.
You may find the pg_dumpall --clean option useful, so the dump file is
://www.gnu.org/software/tar/manual/html_node/tar_149.html#SEC149
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Am Donnerstag, 3. Januar 2008 schrieb Sofer, Yuval:
I need to get PGDATA location when I logged in as non-postgres user.
Consider writing a security-definer function that retrieves the information.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end
Am Freitag, 28. Dezember 2007 schrieb Mark Steben:
As we go. I am investigating using the new tablespace facility to move our
biggest and most accessed
I didn't see anything in your description about having the WAL on a separate
disk. You should include that in your plans.
--
Peter
Julio Leyva wrote:
also make sure you started postgesql with -i option, so you can connect
from the lan
He said he had set listen_addresses to '*', which is equivalent.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
Why is it not allowed to call pg_start_backup when WAL archiving is off?
Wouldn't this be useful as a discrete file system backup without PITR
capability?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP
Jeff Larsen wrote:
On Nov 25, 2007 8:24 AM, Peter Eisentraut [EMAIL PROTECTED] wrote:
Why is it not allowed to call pg_start_backup when WAL archiving is off?
Wouldn't this be useful as a discrete file system backup without PITR
capability?
Because a file system level backup is no good
driver. If
so, see http://jdbc.postgresql.org/.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
-functions.
the running configuration is:
Note that the configuration doesn't mention the libxml switch, so you forgot
something somewhere. Did you do a make distclean before rebuilding, and did
you install the new build?
--
Peter Eisentraut
http://developer.postgresql.org/~petere
), and only if some files were truncated while being archived.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
to the libpq of your choice.
There are a few ways to get this wrong. On Debian the socket location is
usually the first indicator, but you ought to be careful in general if you
mix installations like that.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
Am Mittwoch, 15. August 2007 16:20 schrieb George Wilk:
I thought that the major release was the first number in the versioning
schema, the second represented minor release, and the third would be the
maintenance release or revision number (i.e. 8.2.4).
You thought wrong then.
--
Peter
it.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
.
In my case it is /usr/local/pgsql/data.
That should be your -D argument then.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose
Jessica Richard wrote:
What is the difference between varchar and text for a string column?
Nothing, if you don't use a limit for varchar.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: if posting
into file permission
issues after the build is done.
My build.log shows:
Nothing in the build process requires a special user account or writes a file
named build.log or writes messages of that kind. So please be more specific.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Joost Kraaijeveld wrote:
Can I somehow use another partition to store
the temporaray files without changing my /tmp mount?
Set the environment variable TMPDIR.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
be confusing something.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
Am Freitag, 4. Mai 2007 15:11 schrieb Carol Walter:
Can I add a port in postgresql.conf and still maintain 5432?
No.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL
sufian khan wrote:
How I decrypt any password that is store in our database table
app_users.
That would seem to strongly depend on how you encrypted it in the first
place.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
[EMAIL PROTECTED] wrote:
I've got PG 8.2.3 running on a dual-core P4, and I noticed that, at
least during reindexing, postgreSQL REINDEX process is using only 1
of those 2 cores.
One process, one CPU (core) -- you can't do anything about that.
--
Peter Eisentraut
http
Am Donnerstag, 12. April 2007 16:46 schrieb Chris Hoover:
Is there not a way to query the pg_ catalog views and get a listing of
views with columns (by alias name)?
The column names (what you call alias names) are in pg_attribute, the views
are in pg_class.
--
Peter Eisentraut
http
Karthikeyan Sundaram wrote:
I tried a plpgsql block from the php.
plpgsql blocks only work in a plpgsql function.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
with everything else on your
system in ways that are hard to define in brief, so interfacing with
other libraries or modules will possibly be broken, as will your next
PostgreSQL upgrade.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
Igor Neyman wrote:
But besides having ip address (instead of machine name), it doesn't
have clent program name connected to PG.
That information is not available to the server.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
Gémes Géza wrote:
I have successfully deployed krb5 or pam (with pam_krb5)
authentication with my clients.
My question is: Can I use both in a failover fashion?
Not in PostgreSQL, but you could probably hook Kerberos into PAM.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
usually refered to the GNU make program as gmake,
but I see an increasing number of systems, including my own, that no
longer installs GNU make as gmake but only as make. So basically
you just need to be careful what you call.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
Ray Stell wrote:
Is there a method to rename a cluster?
Clusters don't have names in the first place.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map
Ray Stell wrote:
What I was trying to get at is, is mv of the dir ok or
is there something else that needs to be considered? Thx.
Renaming the directory is OK. Just make sure your init script or
whatever finds it.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
building with
anything less than -O2 for anything but debugging purposes or coping
with buggy compilers on rare architectures. In other words, there
isn't any good reason not to do it.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
this, but anecdotal
evidence suggests that this combination will not work. In general, the
data file compatibility is determined by some combination of
architecture and compiler settings.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
Thomas Papke wrote:
Right now our 8.1.4 is running without any compiler options. Any
possible problem if i will compile the 8.1.8 with CLAGS -O2
-march=Opteron -- will the datafiles of the 8.1.4 non optimized
postgres make any problems?
No.
--
Peter Eisentraut
http
Moiz Kothari wrote:
What are the reasons of data getting fragmented in postgres?
What do you mean by that?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project
to make target `/contrib/contrib-global.mk'. Stop.
analise3:/postgres/share/contrib/tsearch2 #
Run configure first.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
that contains 3183024 as a four-byte integer.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
you are distributing I'm not
sure.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
or residents are certainly significant enought to make this true for the
purpose of export or embargo control.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
, not sure), but so far no one has proposed to
define any operators whatsoever on the XML type, so I don't see where
any indexing mechanism would come from at the moment. What does Oracle
offer?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end
Radhika Sambamurti wrote:
1. How is the backup and recovery using WAL logging in 8.2
It's great!
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
Bruce Momjian wrote:
Is there no API to return the name of signals?
There is, but it's not portable. If someone wants to perform an
exercise in writing configure code, look for strsignal() and
sys_siglist[].
--
Peter Eisentraut
http://developer.postgresql.org/~petere
the SQL standard says in matters of XML. Whether
either of these are equally powerful as what Oracle offers, I can't
say, but since we're currently working on enhanced XML functionality in
8.3, I invite comments on that.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
Joshua D. Drake wrote:
PeterE do you have a specific TODO I can line item for the pending
8.3 release?
http://developer.postgresql.org/index.php/XML_Todo
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP
Manuel Trujillo wrote:
The problem: Encoding incompatibilities between the postgresql
version.
In detail?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
you trust DRDB and Postgresql completely.
If you don't trust PostgreSQL, why would you trust its offline recovery
tools?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: In versions below 8.0
because it dumps users as roles, but
roles don't exist in 8.0.
8.0 dump won't install into 7.4 because it dumps tablespaces, which
don't exist in 7.4.
etc. etc.
Obviously you can see that getting pretty bad if you want to go from 8.1
all the way to 7.3.
--
Peter Eisentraut
http
Craig W wrote:
I am sure that there will be benefits of upgrading, but are there any
known problems with upgrading ?
Please also let me know if it is a painless transition.
RTFM?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
backup and all my new data is lost, the problem begin when
some user close the program improperly.
Closing the program improperly would not cause database corruption.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
=earthdistance.sqlsearchmode=searchfilescase=insensitiveversion=stablearch=i386
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
Cassiano, Marco wrote:
Is there a way to modify
the UMASK used by postmaster to create the logfiles ?
No. You should use syslog if you have extraordinary log file management
requirements.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end
or stick with 7.2
(not recommended, because 7.2 is not maintained anymore).
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe
.)
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through
data appears to be in the future.
You can just commit dummy transactions until it appears again. This is
obvious not an official and approved way, but it's at least a shot
before you're forced to get out your hex editor.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
have special requirements
like that, you need to patch the source.
The other option is to decorate your server log lines with pids and such
that you can link from the deadlock error message to the logged
statements.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
being restored before other objects would exists.
You should have more success if you use the pg_dump(all) program from 8.1.4 to
create the dump.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: Have you
.
That is, for practical purposes, correct.
May I suggest that you properly normalize your tables, by putting given
name and family name into separate columns.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1
scheme of things, first normal form will
cooperate better with established sorting rules (for any data type),
and vice versa.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 4: Have you searched our list
, for example,
alter the logging settings in your .psqlrc file.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
, and the output of SHOW
lc_collate.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so
command from the shell. If that doesn't help, show us the data.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail
of memory bloat
on the background writer process?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
Am Freitag, 4. August 2006 17:00 schrieb Tom Lane:
Are you sure it's bloat, and not just a reflection of the fact that it's
touched every page of the shared buffers over its lifespan?
That seems to be the explanation.
--
Peter Eisentraut
http://developer.postgresql.org/~petere
passwords.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Am Montag, 24. Juli 2006 14:53 schrieb Mans:
Isnt it a crazy thing??
Yes, but with deferrable constraints and transactions blocks, it should be no
problem to manage the data.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast
1 - 100 of 432 matches
Mail list logo