t; >
> > > Thanks,
> > > Peter Geoghegan
> > >
> > > --
> > > Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> > > To make changes to your subscription:
> > > http://www.postgresql.org/mailpref/pgsql-general
>
m glad to see our documentation mentions this
usage:
http://www.postgresql.org/docs/8.4/static/sql-createindex.html
Another possible application is to use WHERE with UNIQUE to enforce
uniqueness over a subset of a table.
--
Bruce Momj
eletion guarantees that they will
> have problem vacuuming or something.
My guess is that they are not vacuuming all databases so old clog files
cannot be removed. That, combined with the fact they are runing 7.4
would incline me to get as far away from that system as possible so as
not be blame
our TZ difference is really only 10
> if you go the other way.
Is PL/J still being developed? I can't find it myself, but was curious.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ndles csv according to rfc4180?
Wow, I had no idea there was an RFC for CSV. Could you test and tell us
how we compare --- that would be a good thing to document.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
--
Sent via p
eSQL 8.1
> > PPAS 8.3x = PostgreSQL 8.2 base (plus HOT and wal_writer)
> > PPAS 8.4 = PostgreSQL 8.4 (plus compatibility)
> > PPAS 9 [is planned to] = PostgreSQL 9.0
>
> So there was no actual 8.3 base release of PPAS?
No, and I assume the version numbers will all
the fsync to
happen on the master (unless I am totally missing something). With
fsync off, you can get into cases where the heap/index files are pushed
to disk before the wal gets written to disk, causing the system to be
inconsistent in case of a crash replay.
I think the only use of fsync off is
Tomas Vondra wrote:
> On 22 Listopad 2011, 18:16, Bruce Momjian wrote:
> > Tomas Vondra wrote:
> >> While I don't recommend it, fsync=off definitely is an option,
> >> especially
> >> with sync replication. The synchronous_commit is not a 1:1 replacemen
y there is no way to do that. There are so many ways to mess
things up with a bad query that we are unclear if restricting work_mem
is really helpful.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for every
fact refer to the same data set...
Wow, that is a reasonable thing to want available via SQL, but I can't
see a way to get to it.
The only method I can suggest is to write a server-side C function that
calls GetSystemIdentifier().
--
Bruce Momjian http://mom
Joshua D. Drake wrote:
>
> On 12/08/2011 12:57 PM, Bruce Momjian wrote:
> >
> > Chris Redekop wrote:
> >> Is there any way to get the database system identifier via a select
> >> statement? I have a primary/secondary async replication setup, and I'd
&g
WordNet dataset that happily uses the UTF8
encoding?
Bruce
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ery
happy with the multi-process, highly-concurrent nature of PostgeSQL.
Thought this might be of help to anyone else out there who comes across
this AV software during deployment and starts encountering strange behavior.
bruce
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
ce the mistakes take place
> within the same record.
Can you give me a self-contained test case I can use so I can use it to
fix the to code?
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everyth
n't modify
the old cluster so you should be fine in reverting to that.
As far as why it ran out of memory, I have no idea, and have never heard
of a report about that before. Can you run it in a debugger and get a
backtrace?
--
Bruce Momjian http://momjian.us
EnterpriseDB
On Mon, Feb 13, 2012 at 02:50:12PM +0100, Wim Bertels wrote:
> On vr, 2012-02-10 at 19:25 -0500, Bruce Momjian wrote:
> > On Mon, Dec 12, 2011 at 07:15:12PM +0100, Wim Bertels wrote:
> > > Hallo,
> > >
> > > psql latex output format needs to d
sed space in tables, but
making that lower is expensive to performance.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-general mailing list (pgsql-gen
them out.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
ptions?
You can shut down all three servers, run pg_upgrade on all of them, then
restart them as 9.1 servers.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql
On Mon, Mar 19, 2012 at 03:07:02PM -0700, Jeff Davis wrote:
> On Mon, 2012-03-19 at 15:30 -0400, Bruce Momjian wrote:
> > On Thu, Mar 01, 2012 at 02:01:31PM -0800, Lonni J Friedman wrote:
> > > I've got a 3 node cluster (1 master/2 slaves) running 9.0.x with
> > >
to do it that way (although still a lot more work than
> simply running pg_upgrade on all servers).
Hey, wow, that is an excellent idea because rsync is going to realize
that all the user-data files are exactly the same and skip them --- that
is the winner solution. I should probably add th
On Tue, Mar 20, 2012 at 02:58:20PM -0400, Bruce Momjian wrote:
> On Tue, Mar 20, 2012 at 11:56:29AM -0700, Lonni J Friedman wrote:
> > >> So how can you resume streaming without rebuilding the slaves?
> > >
> > > Oh, wow, I never thought of the fact that the syst
ok
at the speaker list from last year, it has almost all the server
developers in attendance.
In fact, if anything, it might have too much technology focus and not
enough hands-on/admin focus for you.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://ent
I assume there are no current users of the BSDi, BSD/OS port that are
going to be upgrading to Postgres 9.2. Therefore, I propose removal of
that port in Postgres 9.2. Any objections?
--
Bruce Momjian http://momjian.us
EnterpriseDB http
hema at a point in time, i.e. it doesn't apply to
objects created _after_ that command was run.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent
> Did you come up with a patch for this?
>
> A more polished version on page 7 and 8 of the pdf,
> in attachment:
> 1. include the psql latex a separate file
> 2. use longtable instead of table
> 3. if horizontal lines are needed they can easily be uncommented
e_series(1,5) as a(b);
string_agg
--
JWNRUIEPJQGDVBXDJDTROFSNMKGVNAQWWEORMSHV
KNYGOWJXBEPOJICURIQGIIDFMRXYLFUUSTCIRLGR
PVHXEITVQKBZREFEVDDHHYCASEIKPOCFJJDNRWJJ
HKIYONDLQGSXFUXXZGHPUKUESXRLUATBLCAAPDLG
JEENYCLYISODDIGWGXHBYCCJECJTFUAOYECXGNW
On Wed, May 02, 2012 at 04:03:01PM -0700, Adrian Klaver wrote:
> On 05/02/2012 11:42 AM, Bruce Momjian wrote:
> > On Wed, Mar 28, 2012 at 01:54:58PM -0700, Adrian Klaver wrote:
> >> On 03/28/2012 09:54 AM, leaf_yxj wrote:
> >>> For oracle, the normal user can't
On Wed, May 02, 2012 at 12:31:02PM -0400, Bruce Momjian wrote:
> I assume there are no current users of the BSDi, BSD/OS port that are
> going to be upgrading to Postgres 9.2. Therefore, I propose removal of
> that port in Postgres 9.2. Any objections?
Port removed for Pos
s, but it's meant mostly as a protection against failures at the
> I/O level. It might catch some memory issues, but it certainly won't be
> 100% protection.
Postgres 9.2 will _not_ support checksums.
--
Bruce Momjian http://momjian.us
EnterpriseDB
Gurjeet Singh wrote:
> As I read it, he is supportive of the community process that PG follows; I
> am not so sure he promotes Postgres though :)
I based my comments on discussions I have had with him, not based on his
blog.
--
Bruce Momjian <[EMAIL PROTECTED]>http:
> This should return 'infinity'::timestamp.
>
> Is it possible?
TODO has:
o Allow infinite intervals just like infinite timestamps
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard
n they probably have no basis for comparison. It's all
> good though, I'm just cranky tonight.
I am sure there are smart people at all the database companies. I do
believe that open source development harnesses the abilities of its
intelligent people bett
docs/8.3/interactive/app-pgrestore.html
>
> you may have found a bug..
Added to TODO:
Add support for multiple pg_restore -t options, like pg_dump
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a
Added to TODO:
Add support for returning multiple result sets?
* http://archives.postgresql.org/pgsql-general/2008-10/msg00454.php
---
Pavel Stehule wrote:
> Hello
>
> 2008/10/15 Bruc
Steve Henry wrote:
> I am looking for a mac platform installer for what I was told I
> needed, pgcrypto.
>
> Assistance finding this would be appreciated...
It is part of /contrib. I am not sure where it is in the mac installer.
--
Bruce Momjian http://momjian.us
available at
the time.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make change
to TODO:
Have \d on a sequence indicate if the sequences
is owned by a table
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
--
Sent via pgsql-gener
e source must be a list of
> > independent expressions."
> >
> > Is this feature going into postgresql any day soon? :-)
> >
> It's on the TODO list:
>
> http://wiki.postgresql.org/wiki/Todo#UPDATE
Also, I don't know if anyone working on this
ch also appear in
> pg_constraint.
Can someone come up with better documention wording for conkey? I
can't:
http://developer.postgresql.org/pgdocs/postgres/catalog-pg-constraint.html
--
Bruce Momjian http://momjian.us
EnterpriseDB
rather than requiring a server restart
Unlike SSL CRT files, CRL (Certificate Revocation List) files are
updated frequently
*
http://archives.postgresql.org/pgsql-general/2008-12/msg00832.php
--
Bruce Momjian http://momjian.us
*
http://archives.postgresql.org/pgsql-general/2009-01/msg5.php
---
Karsten Hilbert wrote:
> Bruce, et al,
>
> given the thread partially quoted below would this warrant a
> TODO i
hubert depesz lubaczewski wrote:
> 1. pg_dump -d - do i need to explain?
I wonder if we should just rename the -d behavior to something else and
throw a proper error (or ignore the flag if it is before the dbname).
--
Bruce Momjian http://momjian.us
Enterpris
doesn't help scalability at
> all. You end up having different tables each with different permissions,
> or having to create a view with a ruleset attached, having to update the
> view for each definition change in the view.
Column-level privileges will be in Postgres 8.4.
> VACUUM. This was once our single biggest source of user complaints. Between
> Autovacuum improvements and HOT previously and the free space map in 8.4 the
> situation will be much improved. However there are still some common usage
> patterns where people run into problems.
Yes, that is surpr
Octavio Alvarez wrote:
> On Fri, 2009-01-30 at 15:32 -0500, Bruce Momjian wrote:
> > Octavio Alvarez wrote:
> > > On Thu, 2009-01-29 at 13:16 +, Gregory Stark wrote:
> > > > So, what do people say? Is Postgres perfect in your world or does
> > it
> >
wstrzalka wrote:
> * stat collector is really greedy by definition even when system is
> idle, when you have really really many relations
I think this will be fixed in 8.4.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
estion is: is there any commercial solution for on-line backup
> directly to tape device, eg like HP Data Protector or EMC NetWorker
> module for Oracle?
Can you just open the tape drive in append mode and keep writing to it
as a file?
--
Bruce Momjian http://momji
Karsten Hilbert wrote:
> On Wed, Jan 21, 2009 at 01:49:44PM -0500, Bruce Momjian wrote:
>
> > Tom Lane wrote:
> > > Karsten Hilbert writes:
> > > > This is what my 8.3 manual says:
> > >
> > > > conkey ? int2[] ? pg_attribute.attnum ? If
Can someone comment on this?
---
Hiroshi Inoue wrote:
> Hi,
>
> This topic seems to be related to the bug report
> [ODBC] Localized error messages, wrong charset
> .
>
> Bruce Momjian wro
ears
of momentum; they do catch up, but it takes time.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
the ability of
> making a rollback in case one of the clients says something went wrong.
> Is it possible to do that?
No.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your ba
memory it uses for storage.
The only thing I can suggest is posting the application source code
somewhere in hopes we can see the problem somewhere.
I have never heard of a similar report, so odds are there is something
wierd happening in your application.
--
Bruce Momjian http://mom
collation and ctype both are "German, Germany"
>
> As a result: this basic information command is rather unreadable with
> only 80chars.
You might try the new psql option:
\pset format wrapped
to see if it looks better.
--
Bruce Momjian http://mo
d width. If \pset columns is
zero (the default), wrapped mode only affects screen
output and wrapped width is controlled by the environment
variable COLUMNS or the detected screen width. If
\pset columns is set to a non-zero value, all output
is wra
orks.
Great. The wrapping mode is a new 8.4 features so it os good to know it
is working for you.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
--
Sent via pgsql-
uming
> downgrading (just incase things don't workout that easily) will be equally
> painful.
Actually, pg_migratory will allow upgrades from 8.3 to 8.4 so you could
upgrade to 8.3 and upgrade to 8.4 rapidly. I am unsure if an upgrade
from 8.2 to 8.4 is possible.
--
Bruc
Abdul Rahman wrote:
> Hi all,
>
> Is there any preferably open source tool to convert Oracle
> Functions to PostgreSQL Functions.
No, not that I know of. I assume you mean user-created functions.
There is orafce for adding Oracle functions to Postgres.
--
Bruce Momjian
process is running,
> isn't it?
Wow, you are carrying around a lot of MySQL baggage with you. ;-)
You should probably read this:
http://www.postgresql.org/docs/8.3/static/mvcc-intro.html
--
Bruce Momjian http://momjian.us
EnterpriseDB
So if you want to become the maintainer and test/send patches at an
> earlier stage, please go right ahead!
Yep, send us the changes and we will blindly apply them. ;-)
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life
27;t that much work. The only downside is
that you have to create/use a custom data type for this.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
--
Sent via pgsql-gen
cally, I would like to be able to have Unicode columns and
> > ASCII text columns within the same table. Is this possible? If so,
> > how
> > do I achieve it?
>
> Any valid ascii string is also a valid utf8 string. You can probably
> just use utf8 for everyt
uot;incorrect" way.
>
> I'm going to go on the record now that if Bruce gets pg_migrator
> working for 8.4 (which he seems to think might still happen) it's
Yes, I can confirm I think pg_migrator will work for 8.3->8.4 upgrades;
I start testing this week.
--
Bruce M
Thomas Kellerer wrote:
> Bruce Momjian wrote on 22.04.2009 20:26:
> > Yes, I can confirm I think pg_migrator will work for 8.3->8.4 upgrades;
> > I start testing this week.
> >
> This is pretty good news, cool.
>
> Will there be Windows binaries for the pg_migr
own bug:
Diagnose problem where shared memory can sometimes not be attached by
postmaster children
* FATAL: could not reattach to shared memory (Win32)
http://archives.postgresql.org/pgsql-general/2007-08/msg01377.php
--
Bruce Momjian
gt;
> When designing a somewhat complex DB this become a relativly large
> problem, and this don't sound nice to my boss if I have to tell his
> these thing :-(
We hope to have shared row locks in 8.1 for this usage.
--
Bruce Momjian| http://candle.pha.pa.
Tony Caduto wrote:
> Bruce,
> On another note, is there plans to improve the type checking of stored
> functions during the save/compile?
> Currently I can pretty much make tons of mistakes (on purpose of course
> :-) and they are not flagged as errors until runtime.
> The b
gt; 8.1 is not that far away, and shared row locking will be in it, I won't
> bother patching 8.0 to skip FK parent row locking altogether (which is
> not the most orthodox way to avoid the FK related deadlocks)...
I would guess 8.1 is perhaps a year away.
--
Bruce Momjian
Bo Lorentsen wrote:
> Bruce Momjian wrote:
>
> >We hope to have shared row locks in 8.1 for this usage.
> >
> >
> Thanks, and good news, and just what I hoped for. Are there some kind af
> priority orderet todo list somewhere ?
Sorry, no priority because we are
Steve Crawford wrote:
> On Saturday 12 February 2005 4:09 pm, Bruce Momjian wrote:
> > Added to TODO:
> >
> > * Add IP address to pg_stat_activity
>
> I like it. How about IP and port to differentiate multiple connections
> from the same host? Will this su
Filter: (("language" = 'aa'::text) AND (id_category = 11))
> (6 rows)
>
> Time: 1.020 ms
>
> Thanks per advance for your ideas ...
>
> Regards,
> --
> Herv? Piedvache
>
> Elma Ing?nierie Informatique
> 6 rue du Faubourg Saint
itdb during RC, so yea I
would do the initdb just in case.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup.| Newtown Squa
version of postgres supports this?
>
>
>
> You may provide me some reference links for further information too.
I would pick a similar platform, find all relivant strings for the port
name, and start adding your port, and making modifications, then send us
some p
? I assume you mean only
supporting '' for literal quotes rather than \' too.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be
[EMAIL PROTECTED] wrote:
> Bruce,
> here is a example:
> (there is a simple error in the function that does not get caught when
> running the query in 8.0)
>
> CREATE or REPLACE FUNCTION annual.get_ratio( float8, float8)
> RETURNS pg_catalog.float8 AS
> $BODY$
> DECLAR
in the code and got confused. It needs clarity.
Right now it sounds like you need more when you don't.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Ro
and stuff, but I don't see
people complaining that has to be portable.
I think most of it is done in parser/scan.l if you want to hack in there
and get a test implementation working and send in a patch. We can work
on the infrastructure to turn it on and off.
--
Bruce Momjian
ad of bookview
>
> create rule bookviewdel as on delete to bookview do instead (
>
> delete from book where id=old.id;
>
> delete from item where id=old.id;
>
> );
>
>
>
> -- everyone has access to bookview
>
> grant all on bookview to public;
>
&
al-
> > [EMAIL PROTECTED] On Behalf Of Bruce Momjian
> > Sent: Friday, February 25, 2005 6:23 PM
> > To: Rick Schumeyer
> > Cc: 'PgSql General'
> > Subject: Re: [GENERAL] Is this correct behavior for ON DELETE rule?
> >
> >
> > Uh,
tions. You should increase
> max_fsm_relations.",numRels)));
> +else
> +if (needed > MaxFSMPages)
> +ereport(LOG,
> +(errmsg("the number of page slots needed (%.0f) exceeds
> max_fsm_pages (%d)",
> + needed,MaxFSMPages),
> + errhint("You may want to increase max_fsm_pages to
.
---
Ron Mayer wrote:
>
> On Fri, 25 Feb 2005, Bruce Momjian wrote:
> > Tom Lane wrote:
> > > Ron Mayer <[EMAIL PROTECTED]> writes:
> > > > Should the relation overflow be a WARNING or a LOG? ...
> > > I'd go for making them both LOG, I think. Mor
in fields,
> and the rest can be Latin1?
No, we don't support per-table or per-column encodings yet either.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Robert
Hemapriya wrote:
> Hi,
>
> Does postgres support any system functions that
> decode/decrypt the user passwords stored in pg_shadow
> system catalog.
>
> Is there a way to retrieve the passwords, if
> forgotten.
No. They are MD5 and are designed to be unencryptab
transaction?
>
> (This guy Tucker comes up with some interesting stuff...) :)
It is the only known way to control triggers though it isn't regularly
tested by the developers.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 35
mber I can confirm that "we = Tom" in this context. The
core group has made no decisions about the relative stability of Win32
vs Unix, and is unlikely to in the future.
The decision about operating system and stability are to be made by
end-users based on their experience. We do our bes
but I can't make this work.
>
> Example:
> CREATE TEMPORARY TABLE tmp ON COMMIT DROP AS
> SELECT code FROM mytable WHERE code BETWEEN 1 AND 10;
>
> shows error near ON
Our TODO has:
* Add ON COMMIT capability to CREATE TABLE AS SELECT
--
Bruce Momjian
errhint("You have >= %d relations. You should increase
> max_fsm_relations.",numRels)));
> + else
> +if (needed > MaxFSMPages)
> +ereport(LOG,
> +(errmsg("the number of page slots needed (%.0f) exceeds
> max_fsm_pages (%d)",
> + needed,
llow objects to be moved to different schemas
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup.| Newtown Square, Pennsy
if VERBOSE or some GUC variable is set?
You didn't like server_min_messages = 'notify'?
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
Ron Mayer wrote:
> Bruce Momjian wrote:
> >
> > You didn't like server_min_messages = 'notify'?
>
> I merely don't have a feeling for how much additional stuff
> verbose would be putting in the log files.
You will probably see the
Greg Stark wrote:
>
> Bruce Momjian writes:
>
> > These new messages:
> >
> > NOTICE: max_fsm_relations(1000) equals the number of relations checked
> > HINT: You have >= 44 relations.
> > Consider increasing the configuration par
Alejandro D. Burne wrote:
> Thanks Bruce, then how can I grant an user to create tmp tables and
> drop then it, without gives him global drop priv (I can't grant drop
> priv for the tmp table because don't exist yet)
Perhaps you need a SECURITY DEFINER function. You can set
ared buffer handling to use multiple
> segments. As I'd definitely be willing to give it a go.
We have had some major SMP improvements in current CVS. Were you
testing that or 8.0.X?
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us
Mark Rae wrote:
> On Tue, Mar 15, 2005 at 06:46:50PM -0500, Bruce Momjian wrote:
> > Mark Rae wrote:
> > > Also, while on the subject of scaling. I had the opportunity
> > > to try postgres on a 16CPU Altix and couldn't get it to scale
> > > more than abo
up the db in new location.
> >
> > this could work for you too.
>
> I hadn't thought about using rsync; that's a great idea!
>
> Is there somewhere this could be documented? In an FAQ maybe?
Added to documentation, patch attached.
--
Bruce Momjian
7% faster respectively.
So it seems our entire SMP problem was that global lock. Nice.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup.
mean that Postgres will have stored procs that can have input
> and output params?
Yes.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be you
Stanislaw Tristan wrote:
> It's a possible to compress traffic between server and client while server
> returns query result?
> It's a very actually for dial-up users.
> What is solution?
No, unless SSL compresses automatically.
--
Bruce Momjian
l use, considering
> that checkpoint_timeout can only be set at server start?
I don't see something that happens every five minutes as any kind of
performance problem. I am not sure what Josh saw that made him want to
increase that.
--
Bruce Momjian| http:
Greg Stark wrote:
> Bruce Momjian writes:
>
> > I don't see something that happens every five minutes as any kind of
> > performance problem. I am not sure what Josh saw that made him want to
> > increase that.
>
> I would have thought checkpoint_timeout
701 - 800 of 2119 matches
Mail list logo
