ssage right now because I'd be hiding
from angry customers circling with torches and pitchforks. And Tom Lane
would have already committed ritual suicide in shame.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgs
nerate them. You need to do this sort of dump/reload in order to
convert from a 32-bit to a 64-bit platform.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http:/
epend.objid
FROM tree
JOIN pg_depend ON ( tree.classid = pg_depend.refclassid
AND tree.objid = pg_depend.refobjid)
)
SELECT tree.tree
FROM tree
WHERE level < 10
--
greg
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
at could lead to database corruption. See page 13 of
the presentation for
http://blogs.sun.com/jkshah/entry/effects_of_flash_ssd_on for his quick
note on that topic.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgr
away with a
one-line command for that setting. I reinvent that wheel periodically for
sites that can't or won't install rsync for the job instead (always some
variant on "for security reasons"). Unfortunately those sites also don't
like releasing the resulting code to the wor
that also means that it's
decoupled from what choices you make for that layer. Focus on writing
scripts to atomically copy the files into the right destination on the
standbys, and pg_standby will take care of applying the shipped log files
to the database.
--
* Greg Smith gsm...@gregsmit
g able to keep
standby disk usage pruned easily with the restartwalfile feature comes to
mind, that one is a subtle problem that doesn't sneak up on you until
you've been in production a while.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via p
point where a checkpoint will note
the files aren't needed anymore, and at that point they'll be recycled
(renamed with a new id and used again) or deleted. You can't change the
files until then though, and that time can be several minutes after
archive_command is called.
--
*
On Thu, Jun 11, 2009 at 11:25 AM, Matt Amos wrote:
>
> what problems are we going to create for ourselves if we create a
> btree index on xmin casted to int4? would it be as efficient to use a
> hash index, create a temporary table of txids that we're querying with
> a hash index and do an explicit
On Thu, Jun 11, 2009 at 9:59 AM, David wrote:
>
> Ideally, I'd like postgresql to not do cascading deletes, *except*
> when I tell it to, and the rest of the time fail when the user didn't
> explicitly "opt in" for cascading deletes. When it comes to enabling
> cascading deletes, I don't really lik
On Thu, Jun 11, 2009 at 12:59 PM, Brett Henderson wrote:
> I have a couple of hesitations with using this approach:
> 1. We can only run the replicator once.
> 2. We can only run a single replicator.
> 3. It requires write access to the db.
>
> 1 is perhaps the biggest issue. It means that we only
sql_table_audit.html
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
fo functions you might find
useful documented at
http://www.postgresql.org/docs/8.3/static/functions-info.html as well.
(The pg_toast filter is probably redundant here, I try to keep that in all
these pg_class/pg_namespace join examples because it's handy for more
normal queries)
--
* Greg Smith
This is a recurring debate and there are pros and cons for both sides.
It usually comes down to whether you need transactional guarantees for
these large objects.
There are also practical concerns. Transfering these large objects
over a single database tcp connection limits the application
perform
e
of the other patterns may be a better fit.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
different time periods. Storing all objects representing the same
thing in the same column is just a regular normalized table, not EAV.
You might want to consider partitioning the table of integers by type
to facilitate dropping the old ones. But that's an administrative
trick, not a fundam
e hardest issue specific to
this particular type of application to get right, and a lot of people
don't realize that early enough in the design process to properly plan for
it.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list
-partitioning-database-tables-explain-your-queries/
In that order really; those go from general commentary down to focusing on
specific issues people tend to run into.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general
n the first place. The usual way
tables get unclustered involves random insertion and deletion, and that
just doesn't happen for data that's being imported daily and never deleted
afterwards; it's naturally clustered quite well.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmi
y provisioning and such can give a reasonable system
design for some goals. You just have to recognize that the volumes are
statistically pretty fragile compared to a traditional RAID configuration
on dedicated hardware and plan accordingly.
--
* Greg Smith gsm...@gregsmith.com http://www.g
On Tue, 16 Jun 2009, Michelle Konzack wrote:
Am 2009-06-16 12:13:20, schrieb Greg Smith:
you'll be hard pressed to keep up with 250GB/day unless you write a
custom data loader that keeps multiple cores
AFAIK he was talking about 250 GByte/month which are around 8 GByte a
day or 300
the jobs of the everyone who's been giving your a hard time in
this thread...
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
7;s possible the nature of the corruption
would be clear -- such as a single bit error which makes bad memory a
prime suspect or random bits of garbage from another type of file
which makes the filesystem a suspect. But it's not going to really
help you fix the problem much.
--
greg
http://mi
1)
Filter: (f.commited IS NOT TRUE)
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the
restored database pass integrity checks). Any special-purpose tool
will only prove that the backup passes the checks that that
special-purpose tool checks for. The best way to test what will happen
in a real restore situation is to actually simulate one.
--
greg
http://mit.edu/~gsstark/resume.p
y is the same and which
might make it appear to belong to every process.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, 23 Jun 2009, Ray Stell wrote:
What is the entry point for source and config documentation of the standby
patch?
http://wiki.postgresql.org/wiki/Hot_Standby
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql
ony-I.
Before doing anything else you should upgrade both of these to 8.2.13.
There's no point in running software with known bugs and security
holes when there are updates available.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
for example, it can corrupt the data
before the checksum is calculated, so the block may be stored happily
with a valid checksum for the corrupt data.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscri
can be
done in transactions in Postgres. Then run the tests, still in the
same transaction, and if you detect anything wrong roll the whole
shebang back.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
ok at
http://www.justatheory.com/computers/databases/postgresql/benchmarking_functions.html
which can help you run stuff multiple times even.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
surprisingly
involved in the paste operation so perhaps it's behaving oddly.
Also, what version of readline, X, gnome-terminal, and whatever
application you're pasting from are you using?
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@
On Sat, Jun 27, 2009 at 7:26 PM, Merlin Moncure wrote:
>
> It doesn't matter the source application...it borks regardless if I
> copy from Source insight/wine (my normal editor), gedit, or another
> gnome terminal.
Are these all gtk apps? Try pasting from an emacs or xter
ert since exceptions are moderately expensive. They create a
subtransaction. Probably not a factor for an operation like this which
isn't dominating the workload.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
you'll need to edit in order to change this
situation.
If you still can't resolve your problem, you should ask about it on the
pgpool-general mailing list rather than this one:
http://lists.pgfoundry.org/pipermail/pgpool-general/
--
* Greg Smith gsm...@gregsmith.com http://www.gre
one to claim they hadn't realized they were
trespassing...
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
;t see any clear way to specify that table C should be outer joined
> only if we got a row from table B.
Well that would be the default since if you get no row from b b.c_id
will be null.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@post
lot of update traffic on the customer table so it could require a lot of
careful vacuuming there.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
select max(order_num) from orders where customer_id = :0
insert into orders (order_num,...) values (:0 + 1, ...)
commit;
This uses the lock on customer to protect your insert against someone
else inserting the same order_num but doesn't actually update the
customer table.
--
greg
http://
uld
presumably be your primary key anyways -- that should actually perform
just fine.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
OP
itemid and itemname are your parameters, they're being substituted in
the query so you're getting 10=10 and NULL LIKE '%'||NULL||'%'
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ey're really that spread out it might not make much
difference, and it would avoid having to do all the index scans. You
could experiment with turning enable_nestloop off and see how fast the
hash join plan is.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing
ct than you probably ever wanted to know at
http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm if you
haven't seen that already.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
7;re trying, because eventually you'll reach a point where there are
none of them happening during some test runs.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
. All this poker
talk is bad, I've been staying away from the tables for a while now but
fear this topic is going to pull me back again--just to see how the
database apps have matured, of course.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-ge
ccup he's describing.
Agreed, it doesn't seem like a likely cause. If the problem reduces in
magnitude in proportion with the size of the buffer cache, we might have
to accept that's it's true regardless; that's why I was curious to see
what impact that had on the test re
software
are pretty tightly constrained:
http://www.mysql.com/about/legal/licensing/foss-exception/
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
t is using the older, known bad logic here. See
http://www.solarisinternals.com/wiki/index.php/ZFS_Evil_Tuning_Guide#Device-Level_Prefetching
and http://bugs.opensolaris.org/bugdatabase/view_bug.do?bug_id=6437054 for
details.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Bal
we scan the
index but only pull out one record for each distinct value. I'm not
sure there's anything particularly stopping Postgres from being able
to do them, but it might be a lot of code for a narrow use case.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general
re raid
would be able to handle recoverying. A good server-class RAID
controller should handle those situations without breaking a sweat.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
n't specify a specific data point then
it's a non-deterministic record.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
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, Jul 10, 2009 at 6:37 PM, Jeff Davis wrote:
>
> -- foo has a primary key
> SELECT * FROM foo UNION SELECT * FROM foo;
>
> That's logically equivalent to:
>
> SELECT * FROM foo;
>
> But postgresql will add a sort anyway.
Well no, it's equivalent to S
or later you could
maybe make it work using vacuum freeze but there's no facility to
verify that it's really frozen everything and you'll still be taken by
surprise by queries which try to use temporary space for large sorts
or commands which start transactions that you didn't rea
un
a regular vacuum verbose and use the number of pages from that. That
would have the side benefit of giving you an idea of how densely
packed or bloated each index is which may be a factor in measuring
performance.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing
umption it's an
issue in your app rather than on the server side of things.
P.S. Posting the same question to two lists here is frowned upon;
pgsql-general is the right one for a question like this.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via p
.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
n bugs in 8.2.1 -- that's why the current 8.2
release is 8.2.13.
The next step here is to set enable_seqscan=off and run explain
analyze again. You may have to adjust some costs to sync the estimated
cost with actual run-time.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
tempts we might be able to
explain what's going on.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
that these
queries might be equivalent.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ser defined stuff, views
etc. are all in a given
database so they will be in the pg_dump.
HTH,
Greg Williamson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the insert to the
child table.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
27;t use indexes. Yet,
> EXPLAIN clearly shows it using indexes.
Are you sure you're using 8.2?
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
s was
specifically that they had a policy of choosing implementations that
removed arbitrary limits even if it meant less efficient
implementations.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ssues.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
hmod 600 committed
mv -i committed $PGDATA/pg_clog/0646
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
x27;s thinking of the Petabyte
database at Yahoo:
http://it.toolbox.com/blogs/database-soup/2-petabyte-postgresql-24848
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscript
ccess to only
certain users. But then anyone who has a dump of your database will
have the key which kind of defeats the purpose of using encryption.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your su
r system
will be more secure if the application does not have unnecessary
privileges. So thinking about what rights to grant to the application
for each object when it's created is not a bad thing.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general
;re only responding to part
of it. (That's what people are really talking about when they say
top-posting is bad.)
see:
http://www.theregister.co.uk/2009/07/22/security_offical_suspended/
I don't think there's any actual indication that Apple was involved directly.
--
greg
http:/
tables. One that has
all the data and one that has a second copy of the desirable subset.
Kind of like a "materialized view" of a simple query with the where
clause of "rbscore < cutoff".
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (p
on instead of one controlled by a
single company like flv or quicktime? That would let people play it
using any of various open source codecs which can play mpeg4 part 2.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I would be pretty happy with any page that had a link at
the bottom to download an mpeg format file with H.264 data in it that
mplayer can play.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscriptio
On Wed, Jul 29, 2009 at 12:10 AM, John R Pierce wrote:
> Greg Stark wrote:
>>
>> I think I'm scarred from Quicktime files because they often were
>> encoded with codecs like Sorensen which produced proprietary formats.
>>
>>
>
> agreed, and the quickti
On Tue, 28 Jul 2009, mukeshp wrote:
Can anyone suggest me tools for monitoring postgresql server. ?
An idea what operating system you're running the server on would help
here.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general ma
SIGURG might be useful but it would be more complex to use and less
widely useful since it would only work if the client disconnects
gracefully (though it might be worth checking into as an alternative
to our existing query cancel method).
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via
On Wed, Jul 29, 2009 at 3:17 PM, Tom Lane wrote:
> Greg Stark writes:
>> On Wed, Jul 29, 2009 at 1:58 PM, Jasen Betts wrote:
>>> can't coerce a signal from the network stack? the linux socket(2)
>>> manpage is full of promise (SIGPIPE, SIGURG, SIGIO)
>
>
&
27;::text))
They don't look like the same data from here. One has no matching
records in this table and the other has over 700.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
kend to detect if the
> connection to the client is broken. If it's broken, pgool sends cancel
> packet to backend not to waste backend machine's CPU cycle.
The downside to this is that it will cause spurious failures for
transient network failures even if the network comes back before
On Thu, Jul 30, 2009 at 7:43 AM, Craig
Ringer wrote:
> On Wed, 2009-07-29 at 14:56 +0100, Greg Stark wrote:
>
>> SIGURG might be useful but it would be more complex to use and less
>> widely useful since it would only work if the client disconnects
>> gracefully (though it
d
> until I killed it manually.
Well it ought to have eventually died. Your patience may have ran out
before the keep-alive timeouts fired though.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
dle transactions and killed them, but I imagine
> the hair-pulling for a less experienced postgres DBA. I would have also
> preferred that postgres solves this issue on it's own - the network
> stack is clearly not fast enough in resolving it.
Indeed, properly set TCP keepalive
ng the server try to send data are the
only ways to notice the problem.
Case 2: The server is busy and the client has either cleanly closed
the connection or died but the server doesn't notice for a long time
because it isn't sending any data and it isn't trying to read any data
eit
-(
Yeah, everything I've found on SIGIO indicates it would fire whenever
the socket was readable which isn't what we want. Does anyone have a
pointer for a full documentation on how to use it?
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-g
the same place you grabbed the rest
of 8.3 from in order to put back libpq.so.4.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ing else in it so at least I stay clean.
The TuningWizard software redirects you over to
http://forums.enterprisedb.com for support with it and that's really the
right place to ask questions about that specific program.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimo
it of intellectual property.
I already asked EDB last year whether they were intending to release the
DynaTune program and didn't get the impression that was forthcoming, and
it's unreasonable to ask them to, so I don't know what further questions
you might ask them.
--
* Greg Smi
x27;s message quoted right below them...
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
;m wondering
> if I'm missing some subtle (or not so subtle) point about partitions?
It's purely a convenience issue. Any child partition can be removed
later, The parent will be a pain if you ever want to remove it from
the partitioning structure.
--
greg
http://mit.edu/~gsstark/resu
On Sat, Aug 8, 2009 at 12:08 PM, Jasen Betts wrote:
> select 'a' = any( $${'a','x'}$$ ) ;
postgres=# select 'a' = any( $${"a","x"}$$ ) ;
?column?
--
t
(1 row)
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pg
.
If you have a crash you could lose the last 200ms of commits but if
that happens you'll lose them in a "consistent" way. You can't find
the results of one transaction committed afterwards but not some other
transaction which came earlier.
--
greg
http://mit.edu/~gsstark/resu
up, I expect you'll discover cleaning starts
happening too.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ose who are already managing a
database server on the same system as the browser) is tiny.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ata, it
should work up to the size limits documented at
http://www.postgresql.org/about/ , so you probably having nothing to worry
about here.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
should be
doing and are we violating it in any of these cases?
--
greg
http://mit.edu/~gsstark/resume.pdf
--
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, Aug 13, 2009 at 11:20 PM, Sam Mason wrote:
> On Thu, Aug 13, 2009 at 03:31:39PM -0400, Greg Smith wrote:
>> If your client app is coded correctly to handle large packets of data, it
>> should work up to the size limits documented at
>> http://www.postgresql.org/abo
On Fri, Aug 14, 2009 at 12:33 AM, Sam Mason wrote:
> On Fri, Aug 14, 2009 at 12:03:37AM +0100, Greg Stark wrote:
>> On Thu, Aug 13, 2009 at 11:20 PM, Sam Mason wrote:
>> > There would be no way of creating a row 1.6TB in size in one go
>
> I was thinking of a single up
uption symptoms are you actually seeing?
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t with pg_resetxlog
and then cleaning up but it would be good to see the data first before
changing things.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
035 | (692920,9)
Hm, perhaps I should have asked for xvac as well, as that can also
trigger an "invisible" status. You can't select xvac directly but if
you query cmin it might be possible to tell what's going on.
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-
nd xvac aborted or is in progress (or in future)
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
301 - 400 of 1774 matches
Mail list logo
