7;t ever work before 8.2
--
Simon Riggs www.2ndQuadrant.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
do a bteq export in CSV format and reload using COPY.
It's likely to be faster too.
--
Simon Riggs www.2ndQuadrant.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
mine the contention. Not right now though, fairly busy.
8.4 numbers seem about right, though the #threads at peak seems slightly
off. I think you should look at the point where performance drops down
to 95% or less of peak, which would give a more stable and comparable
figure than just looking
On Wed, 2009-09-30 at 23:48 -0500, Training wrote:
> A training seminar that will put more time back in your life.
Attending PostgreSQL training will help you to target your prospective
customers more effectively and stop wasting their time in the first
place.
--
Simon Riggs
pt when we don't store the null bitmap at all.
Just needs people to make it happen cleanly, if that's possible.
Don't like booleans myself. They tend to end up as 3+ values eventually.
--
Simon Riggs www.2ndQuadrant.com
--
Sent via pgsql-general mailing list (pgsql-
e
don't want to do in the database.
It's possible this is wrong. Is the table being scanned fairly sizable
and was it allocated contiguously? i.e. was it a large table loaded via
COPY?
I also wonder if more L2 cache effects exist.
--
Simon Riggs www.2ndQuadrant.com
--
ns to delete the rows
* insert the rows you wish to keep into a new table then add RI to it,
drop the old, rename the new.
--
Simon Riggs www.2ndQuadrant.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
RDBMS, as Karsten shows. I've seen that implemented in
various ways, from including XML blobs to text strings, EAV tables or
something like hstore.
--
Simon Riggs www.2ndQuadrant.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ture similar to Oracle
> Parallel queries
> Multi Master Replication
>
> Some of the names I've seen
> Tom Lane
> Robert Haas
> Greg Smith
> Simon Riggs
>
> Please let me know if a meeting is possible. There is another in-house
> meeting April 17th where I wou
he Exclusive Lock in this case,
> please? (it's between "d" and "e" tables below)
Locks can be held on databases, relations, rows and also show for transactions.
So the absence of a relation name just means it is one of the other
kinds of lock.
--
Simon Riggs
only NULL then it could
occupy more space.
If you have multiple columns, then you should use NULLs.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
T
ht way to go for
a solution, Bucardo is a good choice.
Just to add other info: if multi-master replication uses pessimistic
coherence, then the coherence mechanism can also be a source of
contention and/or cause the need for alternative kinds of conflict
resolution.
--
Simon Riggs
e..
> Thanks in Advance.
The CHECKPOINT command will do this for you.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
ds are being copied across the internet...
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
uffers and all disk caches as
well to make that effective.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
create table test.my_table_2 (
id bigint not null default public.nextval ('test.my_sequence_id'),
type test.my_type not null,
length bigint,
primary key ( id )
);
Otherwise it tries to evaluate "test.my_sequence_id" as if it were a
scalar subquery, which does not have a FROM cl
ndex fillfactor, not the table fillfactor...
It will be really useful to see some test results where you alter the
fillfactor and report various measurables.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
k, but not PostgreSQL. We can
clear down WAL files even during a long running transaction.
For us, "unneeded" means prior to the second-to-last checkpoint record.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Servic
there if we try to commit while in TopMemoryContext?
That way we'll trap any future leaks in core/add-on code.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-genera
to
split the data into separate sequential files that can be accessed by
multiple writers/reader processes? If so, what was the conclusion?
Finally, thanks for all the good work over the years!
Simon
Simon Windsor
Eml: <mailto:simon.wind...@cornfield.org.uk> simo
On Tue, Jun 7, 2011 at 10:26 PM, Simon Windsor
wrote:
> I have been using Postgres for many years and have recently discover
> Greenplum, which appears to be a heavily modify Postgres based, multi node
> DB that is VERY fast.
>
> All the tests that I have seen suggest that
y sort of CHECK constraint, trigger, custom function, etc?
The most common constraints are provided for, but then after that you
have to use triggers.
PostgreSQL deliberately doesn't support queries in CHECK constraints
for this reason.
--
Simon Riggs http://www.2ndQuadr
Hi
Can the performance of Postgres be boosted, especially on busy systems,
using the none default DEADLINE Scheduler?
Simon
Simon Windsor
Eml: <mailto:simon.wind...@cornfield.org.uk> simon.wind...@cornfield.org.uk
Tel: 01454 617689
Mob: 07590 324560
"There is
cated.
>
> Does anyone know if this is a valid concern and whether or not the temp table
> will be replicated (regardless of the use of file-based continuous archiving)?
So you shouldn't be concerned.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development,
s mechanism is obscure enough that
> I may just write a plpgsql function as a workaround, as that may well
> be more lucid.
I think its a pretty common requirement and we should be looking to
optimize it if it isn't handled well.
The only problem is that there is a few ways o
ngs down to produce a tight
bug report.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
icates that there is a problem in your replication
setup and this is why the slave does not catch up.
This is not a performance issue. It is either a bug in replication, or
a user configuration issue. Since few things have changed in 9.1 in
this area, at the moment the balance of probability is towards us
avoids the error. You'll probably need to fully
re-generate the standby server before doing this.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
r system,
showing their sequence between master/standby. At the moment its not
clear what the first error is. Subsequent messages are less
interesting.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via p
p001_i01 on llamadas_201106_emp001
> (cost=0.00..499258.35 rows=307687 width=854) (actual time=0.053..897.431
> rows=309256 loops=1)
> Index Cond: ((cod_empresa = 1) AND (fecha_llamada =
> '2011-06-22'::date))
> Total runtime: 1335.822 ms
> (3 rows)
form that kind of
UPDATE. It doesn't really make much sense to increment a PK value.
PostgreSQL is good at supporting things people want and need, so
differences do exist in places that are fairly low priority.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development
; start slave. If I stop slave later and restart, yes it could show
>> xlog not found and can not catch master. but why the "invalid" things
>> in the first place?
>
> You might have the same problem which was reported before.
> http://archives.postgresql.org/pgsql-hackers
4.2 port=5432 user=repmgr dbname=repmgr
> (1 row)
>
>
> Does anyone have an idea of what might be going wrong here?
Hi, thanks for using repmgr.
What version of repmgr are you using? What version of PostgreSQL?
--
Simon Riggs http://www.2ndQuadrant.com/
Post
.nz/handle/10063/1710
Could you post a summary, rather than just a link to the whole thesis... thanks.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
On Thu, Jul 28, 2011 at 2:31 PM, Rebecca Clarke wrote:
> I want to search and list all the functions in a database that reference a
> particular table within its code. Is there a way to do this?
No, because functions can execute SQL dynamically.
--
Simon Riggs http
ts of it are actually 7 years old, and they are definitely
battle tested. The slightly newer parts changed the transport logic to
stream rather than use file-by-file.
The features relevant here are Point in Time Recovery (8.0), Warm
Standby (8.2), pg_standby (8.3), Bgwriter during recovery
On Sat, Jul 30, 2011 at 7:57 AM, Toby Corkindale
wrote:
> Many thanks for clearing that up! I hadn't realised that you could only
> change one of the two options on the fly.
The streaming rep options require a restart also...
--
Simon Riggs http://www.2ndQ
On Mon, Aug 1, 2011 at 3:17 PM, Clodoaldo Neto
wrote:
> Restarting the server fixes the error.
There are few things that get "fixed" in PostgreSQL by restarting the
server. That is not a recommended action to take to solve problems
with this software.
--
Simon Riggs
it
> needs to be, an rsync based process might happen fairly quickly. This
> of course means that if you lose the new master before the standby is
> up to speed you are facing data loss. I'm really curious if anyone
> has figured out a potential solution to this problem.
http://pr
ny
> timeline conflicts at all.
>
> Am I using repmgr incorrectly?
It would appear so.
repmgr is not a fix for a problem situation, it is a management system
that will avoid the problems in the first place.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL De
ys could be promoted in such a way that does not require
> a full sync -- that doesn't exist right now AFAIK.
repmgr is specifically designed to reduce the time for a "follow"
action to a very small amount.
There is no risk of significant loss.
--
Simon Riggs
restarting S2. When S2 restarts, S2 reads the
> timeline history
> file which was created by S1 at failover and adjust its timeline ID to
> S1's. So timeline
> conflict doesn't happen.
Though this relies upon a shared archive which gives a single point of failure.
--
Simon Riggs
.postgresql.org/docs/9.1/static/functions.html
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
n.html#FUNCTIONS-RECOVERY-INFO-TABLE
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mail
ime.
Suggest different approach.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
come up."
>
> So how would one "feed" incrementally copied partial WAL file data to
> a standby (actually a new server used for recovery) as suggested
> above?
Using walmgr
http://skytools.projects.postgresql.org/doc/walmgr.html
--
Simon Riggs http
On Sun, Aug 21, 2011 at 11:12 AM, alexondi wrote:
> So, how can I check is the slave-server up and properly work (recovery is in
> progress) in this case?
> Check the log for some messages?
It's certainly more tricky...
--
Simon Riggs http://www.2ndQuadrant.co
ion hotspot.
I think Chris should change his function to a CASE statement so that
his function returns zero when master and slave have matching WAL
positions, and we only calculate the delay when there is outstanding
WAL.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreS
s like a good idea.
NOWAIT is outside the SQL Standard anyway. Oracle doesn't support it
either, but that's their loss as well, I think.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general ma
e and insert scripts based on the resultset.
Probably need to ask on the Servoy list. If it can run a program, it
can do this.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing lis
termining whether you're connected to the
> master or slave database?
SELECT pg_is_in_recovery();
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postg
On Mon, Sep 12, 2011 at 8:19 AM, Toby Corkindale
wrote:
> On 12/09/11 17:13, Simon Riggs wrote:
>>
>> On Mon, Sep 12, 2011 at 7:54 AM, Toby Corkindale
>>> What is the best method for determining whether you're connected to the
>>> master or slave da
sable).
>
> Is this a reasonable approach?
It will work... please read about the functions for pause/resume.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-
asurements on that?
Do you think some funding could be available for that?
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
nto the standby?
>
> Or to put the question another way, is the ordering of transactions on the
> active and standby servers guaranteed to be the same?
Yes, the transaction ordering is log serializable because that's the
only way that provably works.
--
Simon Riggs
server, not a table.
When we have cascaded replication in 9.2, the standby's view of
pg_stat_replication will be necessarily different from the primary.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgs
operator with 2 fields ?
There's nothing in constraint exclusion that depends upon specific datatypes.
Let us know if you find a problem with floats.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via p
ou're using warm standby, but when you say run
pg_start_backup() AFTER each nightly backup I admit to being confused.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-genera
tly backup: shutdown pg on primary, do a file system copy (for
> backup later), start pg again on primary
> c) the next morning, trigger the secondary and run a re-index for
> testing (ERRORS as described in thread)
I see no reason to expect errors there.
Something about your setup is suspe
easy to do.
"Exclusion constraints" are not limited to a single datatype either,
so you should be able to find a solution.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
regenerate the standby than to catchup.
Also, at some point you will run out of space in pg_xlog, which would
make the master crash. So probably best to have an archive_command
that starts deleting or compressing files before disk fills, but that
means your slave can then never catch
So it would be useful to have a non-default option of statement-level
abort for those cases, as an ease of use feature.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@
om. Can you explain?
> Are there risks associated with the `pg_ctl
> restart` approach, or is it safe to use?
PostgreSQL supports both, why do you mention just one of them as a
potential risk?
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Sup
me your feedback on how well that works. I'm
not sure there was any intention for people to buy both.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postg
ptions including outsourcing the data recovery. Any
> help is appreciated.
2ndQuadrant offers commercial data recovery services for people in your
position. We'd be happy to help and regrettably have considerable
experience. If you're interested, please contact us direct/off-list.
--
copied in on mails so that I can see the issues exist. I do not
promise to respond to every mail I'm copied on, though, but it at least
helps me manage the fire hydrant.
Thanks!
--
Simon Riggs www.2ndQuadrant.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
ugh I know of your quieter contributions to other
major projects. Slony alone has been the backbone of PostgreSQL across
many releases and will continue to be important in the future also.
--
Simon Riggs www.2ndQuadrant.com
--
Sent via pgsql-general mailing list (pgsql-gene
Or are we going to
> have to use a separate file?
Run this every N seconds to get the averaged write rate over the period
SELECT pg_xlogfile_name(pg_current_xlog_location());
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Training and Services
--
Sent
On Sat, 2010-09-11 at 14:21 -0700, Gabe Nell wrote:
> Is there a way to get this without using hot standby?
Why would you want to avoid using hot standby?
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Training and Services
--
Sent via pgsql-gene
ons
* current number of sessions
* whether we have two phase commits happening
Thanks
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Training and Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
tgresql.org/pgdocs/postgres/routine-vacuuming.html
VACUUM needs to perform writes to clear up, which generates WAL.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
n essential function and its changes are WAL-logged.
Those changes are an essential part of the structure of the database and
must be included as part of recovery also.
If you think PostgreSQL is somehow different to Oracle, read up on
Deferred Block Cleanout and how SELECT statements can cause ad
r me to do this?
* Transactions ;-)
* PITR
* Build an application-level undo infrastructure using reverse action
triggers.
* Various internal ways not usually attempted.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-general mailing li
/is that setting it away from the default is
only sensible in certain table-specific cases, so such a setting would
more likely result in a general drop in performance.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-general mailing lis
clearly think that adjusting fillfactor helps in all cases with HOT.
I disagree with that, else would have pushed earlier for exactly what
you suggest. In fact, I've has this exact discussion previously.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
L after 8.0 on
Linux, possibly before that also. So upgrade, yes, very soon.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, 2008-07-11 at 15:25 -0600, Scott Marlowe wrote:
> On Fri, Jul 11, 2008 at 3:24 PM, Simon Riggs <[EMAIL PROTECTED]> wrote:
> >
> > On Fri, 2008-07-11 at 14:51 -0600, Scott Marlowe wrote:
> >
> >> I would kindly disagree. I'm looking at a project
On Fri, 2008-07-18 at 20:25 -0400, Francisco Reyes wrote:
> Does pg_snapclone works mostly on large rows or will it also be faster
> than pg_dump for narrow tables?
It allows you to run your dump in multiple pieces. Thats got nothing to
do with narrow or wide.
--
Simon Riggs
es wrong
answers to queries for unsuspecting users).
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ike that won't work. But we add
info to WAL to ensure that inconsistencies are removed from any backup.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
nition of software reliability includes good behavioural
characteristics as well as absence of bugs, then 8.3 is a must.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, 2008-09-18 at 19:29 +0200, Daniel Futerman wrote:
> silent install of PostgreSQL
Please shout about it, don't hide it. And look at stackbuilder.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-general mailing lis
, I thought you were looking after that build. If it's not being
> maintained, we'll need to remove it from the download pages unless
> someone else can volunteer?
I'll look at doing that. We need the SUSE builds also.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL
On Tue, 2008-09-23 at 10:05 +0100, Dave Page wrote:
> On Tue, Sep 23, 2008 at 9:49 AM, Simon Riggs <[EMAIL PROTECTED]> wrote:
>
> >> Oh, I thought you were looking after that build. If it's not being
> >> maintained, we'll need to remove it from the dow
On Tue, 2008-09-23 at 21:05 +0300, Devrim GÜNDÜZ wrote:
> Hi,
>
> 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/R
kpoint and writes a file. No reason for it to
take longer than any other checkpoint.
At 8.2 and below checkpoints were frequently delayed on busy systems.
This was because of lwlock starvation during commit phase of
transactions. That was fixed in 8.3.
--
Simon Riggs www.2ndQuadrant.com
Po
an immediate checkpoint. The idea of this is that "online backup"
should have as little effect as possible on normal running. So I suggest
we change the checkpoint code instead.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-
On Mon, 2008-09-29 at 08:35 -0400, Tom Lane wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
> > I'm surprised that checkpoint smoothing moves slowly even when it has so
> > little to do.
>
> AFAIK that's operating as designed. The point being that we shou
ean).
I've added this function to Infrastructure Changes for Recovery (v8)
patch, with a NOTICE message as suggested also. Seemed easier to work on
it while I was there.
No changes to bgwriter smoothing.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Suppo
, I've seen partitioned designs with more than 100,000
tables. 250,000 is a lot for Postgres, but we should be designing
Postgres to cope with up to 1,000,000 tables or partitions. There's lots
of data out there and if it doesn't come to us it will go elsewhere.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ned above.
All desirable? All possible? Any others?
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
mode.
> > returns bigint
>
> Should these return xid?
Perhaps, but they match txid_current() which returns bigint.
http://developer.postgresql.org/pgdocs/postgres/functions-info.html
Thanks for checking.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and S
On Mon, 2008-10-20 at 17:44 -0300, Alvaro Herrera wrote:
> Simon Riggs escribió:
> >
> > On Mon, 2008-10-20 at 16:22 -0400, Robert Haas wrote:
> > > > * pg_last_recovered_xact_xid()
> > > > Will throw an ERROR if *not* executed i
On Mon, 2008-10-20 at 18:45 -0400, Tom Lane wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
> > On Mon, 2008-10-20 at 17:44 -0300, Alvaro Herrera wrote:
> >> That's been "extended with an epoch counter" per the docs; I don't think
> >> that
ed() returns bigint (txid) seems better.
I am more than happy to add an id version as well, if anybody sees the
need for that. Just say.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, 2008-10-20 at 10:25 +0100, Simon Riggs wrote:
> What else do we need?
> * pg_freeze_recovery()
> * pg_unfreeze_recovery()
Two more functions
pg_freeze_recovery_cleanup()
pg_unfreeze_recovery_cleanup()
These would allow recovery to continue normally, except for ro
On Mon, 2008-10-27 at 11:42 -0400, Robert Treat wrote:
> On Monday 20 October 2008 05:25:29 Simon Riggs wrote:
> > I'm looking to implement the following functions for Hot Standby, to
> > allow those with administrative tools or management applications to have
> > mo
hem. So you need to specify which two servers
you're interested in comparing and how to identify them externally.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
an shed
> some light on this.
Sounds like one for the performance list.
LIMIT prevents the planner from transforming subselects. Maybe you want
EXISTS.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-general mailing list (pgsql-gene
.
Am I right to avoid to VIEWS within application code?
Simon
--
Simon
Simon Windsor
Eml: [EMAIL PROTECTED]
Tel: 01454 617689
Mob: 07960 321599
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
201 - 300 of 550 matches
Mail list logo
