the installer to initialize the database. Please start
the service and try again"
What version of windows are you running, and what's the exact
installer that you have?
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.
On Jul 30, 2007, at 3:44 PM, Geoffrey wrote:
Has anyone taken a stab at adding plperl syntax highlighting for vi?
Hrm, not likely. David Fetter might be able to point you at something.
If you come up with something please post it on pgFoundry so that
others can find it! :)
--
Decibel!, aka
he_size to the same. If you'll be growing
larger than 500MB or so, I'd set effective_cache_size to 875000. If
you move up to a current release, you could set shared_buffers much
higher, but I wouldn't go much past 1GB (131072) in 7.4.
remove NSPAM to email
If you want folks
epted, or you could possibly put
something on pgFoundry. I'd set it up so that ascii() and chr() act
according to the appropriate locale setting (I'm not sure which one
would be appropriate).
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
Enterpr
array_to_set(anyarray) RETURNS SETOF anyelement
LANGUAGE SQL AS $$
SELECT array_to_set($1, 1)
$$;
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgp6qc2KGTEjC.pgp
Description: PGP signature
as defined normally using CREATE TYPE.
>
> You can characterise this as working, just not nicely, but it's still
> a problem for anyone trying to implement unsigned, or any other kind of
> numeric value, as a user-defined type.
Be that as it may, I suspect that if someone puts for
t shows which file vim conf file need to be
> configured and how to
> configure it to use this above .vim file?
Best way to do it is to have an auto command that recognizes a .pgsql
file and loads that .vim file. You could also put it in
/usr/local/vim/syntax and it'd probably work.
--
7;ll be happier with *BSD, Linux or perhaps
OpenDarwin. Personally, I'm past that. I just want the stupid thing to
work with a minimum of fuss so I can get on to doing database stuff. :)
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterpr
tly set 'b_flag' each time I touch a row in the table?
>
>
>
>
> NOTICE: This electronic mail transmission may contain confidential
> information and is intended only for the person(s) named. Any use, copying
> or disclosure by any other person is strictly prohibited. If you have
> received this transmission in error, please notify the sender via e-mail.
>
>
>
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgp9wWogfui3t.pgp
Description: PGP signature
gt; statments continuously.
If you're worried then just use PITR with a more conventional copy
mechanism. You don't have to use snapshots.
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgpWaGvUU0dLL.pgp
Description: PGP signature
use pg_dumpall.
There's a whole different set of concerns with tablespaces and PITR.
Unless you have a real need for tablespaces, just stick with the
defaults.
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgpcYkMlirlSY.pgp
Description: PGP signature
On Sun, Aug 05, 2007 at 08:18:08PM +0530, Merlin Moncure wrote:
> On 8/3/07, Guy Fraser <[EMAIL PROTECTED]> wrote:
> > On Wed, 2007-08-01 at 07:14 +0530, Merlin Moncure wrote:
> > > On 8/1/07, Decibel! <[EMAIL PROTECTED]> wrote:
> > > > David Fetter and
, but normally you'd only run into them in a serialized
transaction. If you're not using that you're probably fine, but remember
that pg_dump and pg_dumpall use serialized transactions.
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enter
omment on that. Neural
> networks, of course, are totally different from fuzzy logic, and address
> different problems. They are not interchangable.
See also http://pgfoundry.org/projects/qbe/ (note that it has *nothing*
to do with QBE as termed by Microsoft and some other tools).
--
Deci
On Tue, Aug 07, 2007 at 06:50:14PM +0530, Rajaram J wrote:
> Hi
>
> I'm having trouble building 64-bit pgsql 7.4.17 on the latest release of
> HP-UX 11.23 on ia64.
I don't believe that's supported. There was just discussion about this,
but I can't find it in the
mns
> without manually copying to a new table and all that is pretty exiting :-)
Patches welcome. :)
BTW, this is much more likely to happen if we divorce presentation order
from actual storage order, something that there is some desire to do
because it would allow the engine to automagically store
rian/JPivot.
> Does anyone has ever used this structure before ? At least Mondrian
> and JPivot ?
I haven't but it's certainly possible to build a datamart without bitmap
indexes or mviews, it's just a question of performance. MViews you can
build yourself easily
nd
seq_tup_read. If seq_scan is a large number and seq_tup_read/seq_scan is
also large, that indicates that you could use an index on that table.
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgp35f1Zcp38S.pgp
Description: PGP signature
doing and post it, it could be useful info.
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgp46sQLvSknV.pgp
Description: PGP signature
ough Usenet, please send an appropriate
>subscribe-nomail command to [EMAIL PROTECTED] so that your
>message can get through to the mailing list cleanly
>
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgpzNdsypMi5A.pgp
Description: PGP signature
er copy of the
database using PITR or some other file-based copy mechanism and try
running VACUUM FULL vs CLUSTER. Note that a copy obtained via pg_dump
obviously won't work for this. :)
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.co
x27;re doing right now would be to wrap everything into
a function and just call that. Depending on your design, that could be
more (or less) "correct" than trying to do it with a trigger.
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgpDGQcJuNi9q.pgp
Description: PGP signature
---(end of broadcast)---
> TIP 5: don't forget to increase your free space map settings
>
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
>
on for that user instead.
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgpwsZ3lNWqxV.pgp
Description: PGP signature
On Thu, Aug 09, 2007 at 09:14:55PM -0400, Steve Madsen wrote:
> On Aug 8, 2007, at 6:08 PM, Decibel! wrote:
> >Something else I like to look at is pg_stat_all_tables seq_scan and
> >seq_tup_read. If seq_scan is a large number and seq_tup_read/
> >seq_scan is
> >also lar
, yet you won't get an error message to say so.
Don't you also need to be in a serialized transaction?
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgpM50NoxGTMF.pgp
Description: PGP signature
hat recent versions check
to see if the key actually changed.
> The question is: is it possible to KEEP this foreign key constraint, but
> avoid deadlocks?
I'm pretty sure that the deadlock is actually being caused by your
application code, likely because you're doing multiple updat
omething that drives a fake workload though your
complete system; that way you can see exactly how everything in the
system will handle load.
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgp5CPDG1bTag.pgp
Description: PGP signature
Does PG support this?
No; you'll need to COPY into a temporary or staging table and then
proceed from there. Alternatively, you could use
http://pgfoundry.org/projects/pgloader/.
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.c
On Wed, Aug 15, 2007 at 01:26:02PM -0400, Steve Madsen wrote:
> On Aug 15, 2007, at 11:52 AM, Decibel! wrote:
> >I can't really think of a case where a seqscan wouldn't return all the
> >rows in the table... that's what it's meant to do.
>
> Isn&
...
> Can you suggest me other point of views to be taken into consideration in my
> case ?
Code maintenance. I can't think of anyway to replace a temp table with
variables that isn't a complete nightmare.
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
Enterp
of that... If you care about performance *at
all*, I'd suggest writing some code that will generate the triggers for
a given table for you. I don't expect it'd be much harder than writing a
completely dynamic trigger.
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgpQrMR6ZYvad.pgp
Description: PGP signature
utils/adt/
ri_triggers.c, I don't see it checking to see if the FK has changed,
which seems odd. I would think that if the FK fields haven't changed
that there's no need to perform the check.
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB h
On Aug 15, 2007, at 2:11 PM, Gregory Stark wrote:
"Decibel!" <[EMAIL PROTECTED]> writes:
On Wed, Aug 15, 2007 at 01:26:02PM -0400, Steve Madsen wrote:
On Aug 15, 2007, at 11:52 AM, Decibel! wrote:
I can't really think of a case where a seqscan wouldn't return
On Thu, Aug 16, 2007 at 01:21:43AM -0400, Tom Lane wrote:
> Decibel! <[EMAIL PROTECTED]> writes:
> > But... taking a quick look at RI_FKey_check in backend/utils/adt/
> > ri_triggers.c, I don't see it checking to see if the FK has changed,
> > which seems o
ghtmare.
>
> With some conversion procedures that is even easiest to do it ;)
Sorry, I'm not quite grokking what you're saying there...
I guess maybe the original question wasn't clear enough... when temp
tables were mentioned I assumed that you were dealing with multipl
5.6
> >million.
>
> But if you go to eBay, they always give you an accurate count. Even if the no.
> of items found is pretty large (example: <http://search.ebay.com/new>).
And I'd bet money that they're using a full text search of some kind to
get tho
to another.
I think you're going to have to give a more explicit example of what
you're actually trying to do.
> i'm not sure if my description is correct - if you dont understand
> something, please let me know.
Well, I'm not following, but it's early in
ouldn't worry too much about it.
Remember the first rule of performance tuning: don't. :)
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgpkB4ZpKaXlM.pgp
Description: PGP signature
ds alias,',')
Note the quotes.
Use dollar quoting... it$$s your friend.
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgpoi3bRybvSj.pgp
Description: PGP signature
So I read up on .pgpass.
FWIW, *IF* you can trust identd in your environment, I find it to be
easier to deal with than .pgpass or the like.
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461
query into another table; perhaps a temp table...
CREATE TEMP TABLE dupe_check AS SELECT ...
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---(end of broa
On Aug 22, 2007, at 3:37 PM, Joshua D. Drake wrote:
You can not do multi master cross continent reliably.
I'm pretty sure that credit card processors and some other companies
do it... it just costs a LOT to actually do it well.
--
Decibel!, aka Jim Nasby[
kely acceptable. If you need
anything more timely than that, you'll probably want to implement
Slony or some other replication system.
Just keep in mind that Slony is *not* a backup solution (though you
could possibly argue that it's log shipping is).
--
Decibel!, aka Jim Nasby
gless until you compare it
to a base backup to see if that WAL file is required for the base
backup, useful (but not required) to the base backup, or useless for
the base backup.
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://en
nto
problems in production (depending on the knowledge of your staff and
the quality of your hardware), it can happen.
(Disclosure: I work for one company that provides PostgreSQL support)
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB h
page so that you could "fix" the
corruption). Obviously, this should be restricted to superusers.
> At least you would know it was corrupted, instead of getting funky
> errors and/or crashes.
Or worse, getting what appears to be perfectly valid data, but isn't.
--
Decibel!, aka
t appear that the
> tempdir is for much other than organizing purposes anyway.
Note that that will only work if you're creating the link on the same
filesystem, and having /tmp and your data in the same filesystem isn't
such a hot idea.
--
Decibel!, aka Jim Nasby
hive_command completes it
> believes it is safe to reuse the old file without deleting it. That will do
> nasty things if you've used ln as your archive command.
I thought that was specifically disabled when PITR was enabled? Or do we
just do a rename rather than an unlink ond creating a n
On Thu, Aug 23, 2007 at 06:58:36PM -0400, Bill Moran wrote:
> Decibel! <[EMAIL PROTECTED]> wrote:
> >
> > On Aug 19, 2007, at 7:23 AM, Bill Moran wrote:
> > >> Assumptions:
> > >> a. After pg_stop_backup(), Pg immediately recycles log files and
x27;s own speed. Slower nodes might then have to queue transactions from
> those until they catch up again.
But is the complete transaction information safely stored on all nodes
before a commit returns?
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgpZMvd5bPlZE.pgp
Description: PGP signature
DESC
>LIMIT 1
>
> How will that effect how I should perform the steps 1-3 above?
>
> Thanks
>
> Thanks
>
> ---(end of broadcast)---
> TIP 6: explain analyze is your friend
>
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgpqj31uWxmiq.pgp
Description: PGP signature
g
> on
Last vacuum, or last autovacuum?
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgpLskOxLbXar.pgp
Description: PGP signature
On Tue, Aug 28, 2007 at 09:54:23PM -0400, Tom Lane wrote:
> Decibel! <[EMAIL PROTECTED]> writes:
> > On Tue, Aug 28, 2007 at 08:31:10PM +0100, Gregory Stark wrote:
> >> Postgres tries to reuse WAL files. Once the archive_command completes it
> >> believes it is s
ee* their updates while you're inside of a transaction.
Just make sure and read up about transaction isolation... in the default
of READ COMMITTED mode, you can sometimes see changes made by other
transactions.
--
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB
y turn off nested loops, what side
effects would
we have to expect?
Are there more granular ways to tell the query planner when to use
nested
loops?
Or just other ideas what to do? We'd be grateful for any hint!
Here's what's killing you:
-> Nested Loop (c
not a recipe for performance on a database, if that's what
you were thinking.
Of course, without having any idea of database size or transaction
rate, it's impossible to tell you if that's a good server for your
needs or not. Maybe all you need is a 486. :)
--
Decibel!, aka Ji
size functions:
SELECT pg_size_pretty(sum(relpages)*8192) FROM pg_class;
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
---(end of broadcast)---
TIP 1: if posting/re
Does anyone have a .vim file that takes dollar quoting into account?
I've tried the one mentioned at
http://archives.postgresql.org/pgsql-general/2006-04/msg01266.php , but
it doesn't appear to understand dollar quotes.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTEC
On Oct 31, 2007, at 9:33 AM, Filip Rembiałkowski wrote:
2007/10/30, Decibel! <[EMAIL PROTECTED]>:
Does anyone have a .vim file that takes dollar quoting into account?
I've tried the one mentioned at
http://archives.postgresql.org/pgsql-general/2006-04/
msg01266.php , but
it doesn&
10_2
I seem to have hit a brick wall. I tried installing postgresql82-
server first but it wouldn't do that without the 8.2 client library
installed.
What's the portupgrade process in FreeBSD??
---(end of
broadcast)---
TIP 6: expla
d actually have to accept something like a
hash; pass in a hash of all the grouping fields and whenever that
changes you reset the total.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
damages both the primary and the secondary. You can never have too
many ways to try and recover from such a situation.
Plus, the new resumable recovery probably won't be happy if you're
too aggressive about nuking WAL logs from the archive.
--
Decibel!, aka Jim C. Nasby, Database
"gem" was provided as a means to see which tables
needs more vacumming.
By itself it doesn't help; you need to track how many rows have been
updated or deleted since the last time you vacuumed. That, along with
the rowcount, will give you an idea of how much of the table is dead
simple
INSERT INTO table VALUES ... but if you think that's bad, try it with
an expensive INSERT INTO table SELECT statement!
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Descript
pg_column_size(3111234::numeric);
pg_column_size | pg_column_size | pg_column_size
++
5 | 10 | 12
Apparently it's something related to numeric.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
eeply enough into the code. This is part
of why char() uses the exact same storage mechanism as varchar().
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
well like
the weight and display precision.
Hrm... perhaps that's another worthwhile target for the varvarlena
technique...
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
ing Postgres group?
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
pgp45Bo8fd3KM.pgp
Description: PGP signature
On Mon, Jan 28, 2008 at 09:07:34PM -0300, Alvaro Herrera wrote:
> Decibel! wrote:
> > On Tue, Jan 22, 2008 at 08:20:30PM +0100, Gevik Babakhani wrote:
> > > Dear all,
> > >
> > > I have created a group for PostgreSQL professionals at LinkedIn.com
support a version for at least 2 years after it's
replacement comes out (ie: 8.2 should be supported for at least 2
years after we released 8.3).
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #18
ace and \S indicates not whitespace (sorry,
don't have a regex manual handy...)
You could probably even simplify that to
\s*vacuum(\s+full){0}
Of course, you'd want to perform all of those in a case-insensitive
manner.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL P
------
TIP 5: don't forget to increase your free space map settings
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
cost_delay to between 10 and 20.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
.
How can I get rid of this sorting? Or could this behavior of Merge
Full Join be improved?
Theoretically, this can be improved, but I suspect it would be non-
trivial. I suspect that the problem is the planner doesn't realize
that the join key could never be null, which is often not the ca
that), but even discounting that 75G is
nothing to sneeze at in an OLTP database.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
vings to consider per-table
HAVING sum(savings) > 1e7
ORDER BY sum(savings) DESC
) a
;
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
pgpPK8JSpK8sA.pgp
Description: PGP signature
e's other ways to do this. Searching the
pgsql-hackers archives should be enlightening.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
database used as a template can't
have anyone connected to it; if somebody was, we can't get a
consistent filesystem-level copy of the database.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
ify
that. You can see what directory it's actually using by connecting
and doing a SHOW data_directory;
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
happen to have any scripts/code that will just trawl
through a database, adding tables to a set one at a time?
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic
in a solid. Presumably somewhat
faster in liquid. Definitely faster in a gas, but you have to have a
pretty good vacuum for them to actually approach the speed of light.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net
urb LEFT JOIN streets ON (streets.urb_id = urb.urb_id )
ORDER BY zipmatch DESC, name
;
Of course you'll need to adjust the table and field names appropriately.
Someone should probably teach the gnumed folks about schemas, too... ;)
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL
On May 12, 2008, at 10:42 PM, Craig Ringer wrote:
Personally I'd be tempted to use a `double precision' (float8) for
things like materials consumption.
Or you could just use an un-bounded numeric...
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your com
On May 13, 2008, at 1:36 PM, Justin wrote:
Is is limit less no, but what is?
numeric is limitless, unless you specifically bound it. Or you run
out of space...
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team
load and the vacuum.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
rely on your own then things
get a lot more complicated.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
one should be OK on 8.1.
Hrm... don't seqscans use a separate set of buffers in 8.3? While
technically those won't be evicted until needed, you're unlikely to
find stuff hanging around there for terribly long...
--
Decibel!, aka Jim C. Nasby, Database Architect
NULLs.
This is version 8.1.mumble.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
me that's brought up, people want to start worrying about storing
conversion tables.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
entually end up clustered if rows are updated often enough.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
that it can't deadlock by itself. Of
course you could always do something like
BEGIN;
SELECT * FROM a;
CLUSTER .. ON a;
COMMIT;
Which does introduce the risk of a deadlock, but that's your fault,
not Postgres.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
the system
so that you don't have conflicts (ie: if you have a bunch of branch
offices, each one is responsible for their own data). You can then
build something akin to multi-master using londiste and pgq.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your c
ock
modes and just test to see if one lock is higher than another.
I think your logic in the view is correct. It might be helpful to
also list how long the queries have been running.
I really wish we had some kind of a site for listing useful queries
like this...
--
Decibel!, aka Jim C.
On Jun 21, 2008, at 8:06 AM, kevin kempter wrote:
Hi LIst;
Is there a way to print all the lines being executed for a
function, like the equivelant of a psql -ef for an sql file ?
No, but you could use a debugger on it if you're running a more
recent version...
--
Decibel!, aka
aling with. But keep in mind that it doesn't
actually look at the values it will be getting, so if you have a
skewed distribution of values in the join column in the larger table
you might be stuck...
--
Decibel!, aka Jim C. Nasby, Database Architect deci...@decibel.org
Give your computer s
in heap_blks_hit included,
or is this
number the additional accesses, after reading the data from disk to
buffer ?
Take a look in the manual; there's a pretty clear explanation in there.
--
Decibel!, aka Jim C. Nasby, Database Architect deci...@decibel.org
Give your computer some bra
e only parts of it?
And how exactly did you make the backups? You can't simply take a
filesystem copy of a running database; that won't work.
--
Decibel!, aka Jim C. Nasby, Database Architect deci...@decibel.org
Give your computer some brain candy! www.distributed.net Te
use the restored copy. I bet
there's probably other problems lurking in your database.
--
Decibel!, aka Jim C. Nasby, Database Architect deci...@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
we should either warn users about STDERR (and
presumably the CVS logging) or change things so that something that
breaks logging doesn't block backends.
--
Decibel!, aka Jim C. Nasby, Database Architect deci...@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
1 - 100 of 115 matches
Mail list logo
