On Wed, Sep 07, 2005 at 12:47:43PM -0700, Qingqing Zhuo wrote:
> Xlog will be the only believable data if your system crashed. So it is a
> dangerous practice to put xlog stuff in RAID0.
No more or less so than putting your main database on RAID0. If any
drive fails, you lose everything.
-
On Wed, Sep 07, 2005 at 01:02:18PM -0500, Scott Marlowe wrote:
> On Wed, 2005-09-07 at 12:40, Jim C. Nasby wrote:
> > On Wed, Sep 07, 2005 at 12:47:43PM -0700, Qingqing Zhuo wrote:
> > > Xlog will be the only believable data if your system crashed. So it is a
> > > dan
>>
> >>
> >Cron can log to syslog.
> >
> >Karsten
> >
> >
> And your cron scripts could log to your database log tables if that is
> what you were getting at...
True and true, but both of those require more work to setup. I'm not
even sure i
On Fri, Sep 09, 2005 at 09:43:56AM -0500, Scott Marlowe wrote:
> On Wed, 2005-09-07 at 16:15, Jim C. Nasby wrote:
> > On Wed, Sep 07, 2005 at 01:02:18PM -0500, Scott Marlowe wrote:
> > > On Wed, 2005-09-07 at 12:40, Jim C. Nasby wrote:
> > > > On Wed, Sep 07, 2005
ODO for this, since it's something that's
asked about fairly often.
* Provide a means for individual queries to be run at a lower priority
While nice allows this for CPU-bound queries, it generally doesn't
work for I/O bound queries.
--
Jim C. Nasby, Sr. Engineering Consultant
tid
HINT: Use an explicit ordering operator or modify the query.
ERROR: could not identify an ordering operator for type tid
HINT: Use an explicit ordering operator or modify the query.
decibel=#
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software
-sql/logdb/ has an example
of this.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of broadcast)--
ngs like random() and such.
>
> Now, if you're arguing against statement based replication, that I can
> understand. but pgpool can definitely do two box sync replication.
Oh, I didn't realize that. Though I have to wonder why they duplicated
what pgcluster provides...
--
Jim
On Fri, Sep 09, 2005 at 06:42:10PM -0500, Jim C. Nasby wrote:
> On Thu, Sep 08, 2005 at 10:49:25PM -0400, Tom Lane wrote:
> > Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > > This has been discussed before, and rejected. Please see the archives.
> >
> > For SE
ry time the combination of (a, b) changes, Oracle
stores a special record of some kind that indicates the change, and it
doesn't store a or b with each row. (Note that I'm guessing on syntax,
it's been a while since I've used Oracle).
> ##
>
> Ji
le strict;
create or replace function _pg_sv_temp_schema(name) returns boolean
as 'select $1 like ''pg!_temp!_%'' escape ''!'' '
language sql immutable strict;
Of course, as others have mentioned, that won't work if you're pre-schem
ts, high traffic volumes, high update rates,
> etc, particularly large, recognizable names. I know you guys get this
> question a lot, but can anyone share experiences with using Postgres in
> large settings with huge query rates, replication, etc? Any stories you
> guys can share (in p
nd region = yyy order by category,
> region, price limit 10;
> which worked blazingly fast.
>
> but what do i do when i store category and region information as ltrees?
> what indices to use? how to build a query?
>
> any help?
> any more information i should give?
> we
aster because the optimizer can discard it right off the bat.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of broa
On Mon, Sep 19, 2005 at 07:23:54AM +0200, hubert depesz lubaczewski wrote:
> On 9/18/05, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> >
> > ltree is part of contrib, right?
>
>
>
> yes.
>
> You probably need to define a functional index of some kind. How a
It does sound like what
> I was looking for.
http://cvs.distributed.net/viewcvs.cgi/stats-sql/tools/ has some scripts
you might find useful for running autovacuum.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231
with the main database on the linux server? There is only one
> table that needs to be updated.
>
> TIA
>
> Art
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.po
ostgreSQL: Past, Present, and Future
> (Bruce Momjian)
>
> --
> Rafael Martinez, <[EMAIL PROTECTED]>
> Center for Information Technology Services
> University of Oslo, Norway
>
> PGP Public Key: http://folk.uio.no/rafael/
--
Jim C. Nasby, Sr
t;
> > PGP Public Key: http://folk.uio.no/rafael/
> -- End of PGP section, PGP failed!
>
> --
> 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
> +
te transaction.
>
> If you need that table to always have the old or new tuples (i.e. never
> be empty) and you can afford the very lengthy vacuum full on the 5
> million dead rows, then that method will give you the best select
> performance the rest of the day.
>
>
I can't seem to find info about this in the docs, or on the web.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569
On Sat, Sep 24, 2005 at 07:19:10PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > I can't seem to find info about this in the docs, or on the web.
>
> http://developer.postgresql.org/docs/postgres/storage-page-layout.html
>
&g
ed very slow.
>
> How can I make it go fast again?
> Thank you.
>
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
--
Jim C. Nasby, Sr. En
On Sun, Sep 25, 2005 at 12:09:24AM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > On Sat, Sep 24, 2005 at 07:19:10PM -0400, Tom Lane wrote:
> >> Currently, when a tuple is reclaimed by VACUUM, we just mark its item
> >> pointer as
g from scratch, don't create the indexes until after the
load is done.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---
cally, anything trying to
access the old table will block for a while waiting for the update to
happen.
But keep in mind that 'a while' will depend on what's happening on the
system. Imagine...
Start long transaction involving table
Run code above; drop aquires lock on table
I *think* that
DROP will. So it will be slightly faster.
In either case, if a user is running a long transaction on the old table
when you try and rename/drop it, that is going to completely swamp the
effects of everything else. So, if you have some long-running queries
that use that table, there is going
ope with it or
> just accept that it works like this...
>
> Cheers,
> Csaba.
I can't think of any explanation for this off-hand. Can you re-run the
test on a table that doesn't have a bunch of free space in it to see if
that's what the issue was?
--
Jim C. Nasby, Sr
the database the exact info it needs to answer your real question, it
can use a much, much more selective index scan.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf
e and checking the output?
> >
>
> Take a look at pg_attribute system table.
> http://www.postgresql.org/docs/8.0/static/catalog-pg-attribute.html
You might find the information_schema or pg_newsysviews
(http://pgfoundry.org/projects/newsysviews/) easier to use.
--
Jim C. Nasby, Sr.
:
http://www.postgresql.org/docs/8.0/interactive/wal.html
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of broadcast)-
to know if
> one of the workers has workers.ib = 't' set if this is true I like to
> have 't' returned else a 'f'
>
> Is this possible in a single query?
>
>
> Sincerely,
>
> Frodo Larik
>
>
>
>
>
> --
ple, multi-column, partial and multi-column
> partial indices. we do not have functional indices.
>
> database has quite huge load of updates, but i thought that vacum will guard
> me from database bloat, but from what i observed it means that vacuuming of
> b-tree indices is
iven that it's scanning 24M rows. An index on
abs(tend-tstart) might help eliminate that. It will also probably help
if you increase the statistics_target for u_all_est_mrna, since it might
be best to join before filtering on abs(tend-tstart), which is the
opposite of what it's doing n
> Joshua D. Drake
> >
> >
> > >
> > > Thanks in advance.
> > >
> >
> >
> > --
> > Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
> > PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
anks a lot,
> Emi
>
>
>
>
>
>
>
> ---(end of broadcast)---
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Jim C. Nasby, Sr. Engineering Consult
es
> gracefully with huge directories, you probably want to avoid having more
> than a few thousand files per directory. (As of PG 8.0 you can work
> around this to some extent by segregating tables into different
> tablespaces.)
Some of the "\ commands" in psql will al
general.
You can query from pg_stat_activity:
SELECT * FROM pg_stat_activity;
or
SELECT count(*) FROM pg_stat_activity;
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf
ve_function is evaluated twice (if
> > > it's not null) ?
> >
> > You can do something like this:
> >
> > select f from
> > (select expensive_function(table) as f from table offset 0) ss
> > where f is not null;
Why the offset 0?
--
Jim C. Nasby,
27;mycn','trka')
>
> might be a candidate for such treatment.
>
> - John Burger
> MITRE
>
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgr
'select proname, prosrc from pg_proc')
>AS t1(proname name, prosrc text)
> WHERE proname LIKE 'bytea%';
>
> --
>Richard Huxton
>Archonet Ltd
>
>
>
> ---(end of broadcast)-------
into queue_table
Then periodically delete from that table using a plpgsql function that
can catch a row count, and use that row count to update your views
table.
But remember the first rule of performance tuning: don't.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Perv
clusive lock on the table it
grabs.
> I'm not a database administrator, and I'm afraid it shows. I'm going to read
> a lot of docs in the coming months, because real people depend on reasonable
> performance of our databases.
If you need immediate help you can get comm
out/licence
>
> It has _got_ to be the easiest piece of legalese you'll ever
Not easy enough to avoid confusion though. :)
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.
ysical access to a machine can obtain any data on (or moving through)
that machine, plain and simple.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf ce
7; as text)"
> PL/pgSQL function "f_create_index_currency_inversion" line 28 at assignment
>
> Note I am using PL/pgSQL.
>
>
> Can you help?
>
> Thanks
> Adam
>
> Adam Lawrence
> Mediasculpt
>
> Direct Line: +64 6 3546038
> Email
x27;? If memory serves, both Oracle
and DB2 have ways to handle updates on views that are not automatically
updateable. What we're missing are *automatically* updateable views.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://perv
out why it
> wasn't doing ANYTHING when I declared an FK reference at column level.
>
> Things like that are, sadly, kinda rampant in MySQL.
Are you aware of the MySQL Gotchas website (just google it)? Any time
you see MySQL being stupid about something you should probably check
there
at would duplicate the features of a federated
system. Of course it would be easier if it was in the back-end...
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf
of
setting a bit in the index once a tuple is visible to all running
transactions. This would be a win on larger indexes that don't have a
lot of insert/update/delete activity.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.co
ree, this is only a gotcha if you're used to the very non-standard
behavior in MySQL.
> * Nits so minor as not to be worth addressing (non-optional AS in FROM
> clauses vs. SQL standard's making that AS optional there)
*shrug* I think it's useful to be able to see why something
On Thu, Oct 06, 2005 at 01:46:29PM -0500, Scott Marlowe wrote:
> On Thu, 2005-10-06 at 12:23, Jim C. Nasby wrote:
> > On Thu, Oct 06, 2005 at 10:10:14AM -0500, Scott Marlowe wrote:
> > > But what really bugs me is that some things that ARE bugs simply aren't
> > >
On Thu, Oct 06, 2005 at 02:30:53PM -0400, Alex Turner wrote:
> MySQL is to linux, what Jet is to Windows IMHO, oh wait - Jet has foreign
> keys by default...
MySQL is the WindowsME of databases <- first hit searching for MySQL on
CafePress. :)
--
Jim C. Nasby, Sr. Engineering C
in/pgtodo?pg_dump), I find myself
wondering if it would be good to allow for specifying a set of rules for
what to dump in a file, probably something like a set of regexes with a
way to specify if it's an include or exclude rule. Seems like it would
be a heck of a lot simpler to do that for c
On Thu, Oct 06, 2005 at 12:54:43PM -0700, CSN wrote:
> - lowercase folding. I DO sometimes wish I could use
> fieldID, etc. without quoting it.
I believe that may be against ANSI SQL. In any case, the only databases
I can think of that don't fold-case in some form are MySQL and Access
http://lnk.nu/prnewswire.com/4dv.pl
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of broadcast
would make it easier to
ensure your config file is correct.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
-
On Thu, Oct 06, 2005 at 11:42:57PM +0100, Mark Cave-Ayland wrote:
> - All the companies that have tried to operate by selling PostgreSQL
> support
> services have gone bankrupt, except for EnterpriseDB.
Damn, guess I need to update my resume...
--
Jim C. Nasby, Sr. En
gets to mark nonvolatile functions
> properly. (Personally, though, I'm in favor of tightening it up.)
Aren't there a good number of performance issues if you mis-mark a
function?
In any case, ISTM it'd be much better to perform poorly rather than give
bad/wrong results. I do
HO, anyone messing around with object
names that won't fold is asking for trouble anyway.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-5
; select a.f, b.f from a,b for update of a for share of b.
> Any hints?
>
> Thanks.
>From http://www.postgresql.org/docs/8.0/interactive/sql-select.html:
FOR UPDATE [ OF table_name [, ...] ]
I'm assuming that the syntax is the same for FOR SHARE.
--
Jim C. Nasby, Sr. Eng
On Sat, Oct 08, 2005 at 02:22:23PM -0700, David Fetter wrote:
> On Fri, Oct 07, 2005 at 08:21:31PM -0500, Jim C. Nasby wrote:
> > On Fri, Oct 07, 2005 at 02:07:47AM -0700, David Fetter wrote:
> > > On Fri, Oct 07, 2005 at 11:47:26AM +0300, WireSpot wrote:
> > > > But
ySQL using the GPL'd version of InnoDB... but of
course if they did that they'd have GPL'd software again, so no reason
to pay for the commercial license of MySQL.
This is the first time I can think of where software being GPL'd might
actually hurt the open-source community.
--
On Sun, Oct 09, 2005 at 03:16:22PM +0200, Martijn van Oosterhout wrote:
> On Sat, Oct 08, 2005 at 05:01:50PM -0500, Jim C. Nasby wrote:
> > Though AFAIK there wouldn't be anything illegal about someone with a
> > commercial license of MySQL using the GPL'd version of InnoD
----
> TIP 3: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faq
>
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf
do the same for
MySQL.
Of course, it gets a bit tricky, since you have to define what is
actually MySQL code... ie, do you count InnoDB stuff?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.
the results of the function, and replace the
> functional index with a real one.
>
> Thanks to all,
>
> Han Holl
>
> ---(end of broadcast)---
> TIP 4: Have you searched our list archives?
>
>http://archives.postgresql.org
>
> they're not captured in some central repository.
Imagine harder. :)
Search the pgsql-bugs archives.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/perva
>
> Speaking of which, I have a customer running PostgreSQL/Bugzilla right
> now and it works
> well for them. Is anyone interested is having us set this up for the
> community?
IIRC the last time this was brought up it was violently shot-down on
-hackers (and the fact th
>
> --
>
> Daniel Armbrust
> Biomedical Informatics
> Mayo Clinic Rochester
> daniel.armbrust(at)mayo.edu
> http://informatics.mayo.edu/
>
> ---(end of broadcast)---
> TIP 9: In versions below 8.0
tus of acknowledged bugs.
>
> regards, tom lane
>
> ---(end of broadcast)---
> TIP 1: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to [EMAIL PROTECTED] so tha
y use them for id fields, as well as some other places where I
knew negative numbers weren't valid.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf
your backup.| Newtown Square, Pennsylvania 19073
>
> ---(end of broadcast)-------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to [EMAIL PROTECTED] so that your
>
On Tue, Oct 11, 2005 at 06:31:06PM -0400, Bruce Momjian wrote:
> Jim C. Nasby wrote:
> > Of course one flip-side to all this is that if Oracle does attack us it
> > actually lends credibility; it means they see PostgreSQL as a threat. At
> > this point that could do more
urned down a job at Oracle about 18
months ago. Before anyone worries though, it was offered by a friend and
PostgreSQL wasn't an issue at all.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard:
ass
> > password as plain text...
> > How peple solve this problem ?
>
> Put the password in a ~/.pgpass file belonging to the user that runs the
> autovacuum task.
Or you can run pg_autovacuum on the server itself and allow ident
authentication for unix sockets (assum
speech is like a good dress
> that's short enough to be interesting
> and long enough to cover the subject"
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
> http://www
On Tue, Oct 11, 2005 at 10:14:37AM -0700, Russ Brown wrote:
> Has there ever been any discussion about moving away from CVS? We couldn't
> possibly go back to it now.
Many times. See -hackers archives.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasi
UE >= 0)
>
> The objection might be that we lose one bit of field width.
> But the extra safety is probably worth it if you really need unsigned
> and want to avoid ambiguity.
Certainly. But I was more interested in the space. :P
--
Jim C. Nasby, Sr. Engineering Consultant [EMA
On Tue, Oct 11, 2005 at 02:22:23AM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > Out of curiosity... why don't we have unsigned ints?
>
> Quick, is 42 an int or an unsigned int?
>
> I think it'd create a slew of new ambi
On Thu, Oct 13, 2005 at 09:35:18AM -0600, Cristian Prieto wrote:
> Why not something like Mantis bug tracker? (http://www.mantisbt.org)
Because according to that URL:
Mantis is a php/MySQL/web based bugtracking system.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervas
owing for only dumping certain rows in a table (applying a
WHERE clause) would be a neat addition to that.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 51
ass file it's still a plain text. How to hide it ?
>
> - Original Message -
> From: "Jim C. Nasby" <[EMAIL PROTECTED]>
> To: "Tom Lane" <[EMAIL PROTECTED]>
> Cc: "Zlatko Mati?" <[EMAIL PROTECTED]>; "Matthew T. O&#
pg_dump handles table ordering properly.
On Fri, Oct 14, 2005 at 10:24:55AM -0500, Dan Armbrust wrote:
> Jim C. Nasby wrote:
> >Since no one else has mentioned it, there has been discussion this week
> >on one of the lists (probably -general or -hackers) about expanding the
>
Sony, etc) - along
> > with a proven business structure (combination of product + marketing)
>
> You do know that many of those listed above also use PostgreSQL :)
Do we know that for sure? It'd be damn nice to be able to put that kind
of info on our website...
--
Jim C. Nasby, S
rt, since it will be
forced to an 8 byte boundary on most systems (int8 requires 'double'
alignment). If you instead used 4 smallint fields, all together, you
would probably only waste 2 bytes. Of course, this is all 100% dependant
on the other fields in the table.
--
Jim C. Nasby, Sr. Eng
faster (assuming you could use something other than C for
this).
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end
mit":
> SPI_ERROR_TRANSACTION ";
>
>
> Can any one send me an example of how to use the start transaction or how to
> commit an nested transaction.
>
> Thanks in advance.
>
>
> Thanks & Regards,
> Sri
>
>
>
--
Jim C. Nasby, Sr. Eng
generated
> chars; we were using UNICODE locale (we're now using WIN1251). Should we
> use bytea, retry varchar 16 (with the new local), or some other column
> type ?? What is going to give us the best performance (with 8.1) ?
>
>
>
> Thank You
>
>
>
> Pa
is a UNION of one VIEW (JOIN of three tables, w/ 0.9
> >million rows) and one TABLE (1.3 million rows). All the other tables
> >are tiny (<100 rows).
> >
> >If I can't fix this, I'll have to go back to 7.4.8.
> >
> >HELP!
> >
> >-- Dean
> >
> >
motivated enough to change support
providers just because it's Oracle, and meanwhile many people would look
to see who else was offering Oracle support.
Of course, Oracle could tank the market by offering support at
un-competitive prices, but I can't think of a reason for them to do that
o
fraction of
> a second under 7.4.x, and runs for hours on 8.0.4.
>
> -- Dean
>
>
> On 2005-10-17 11:17, Jim C. Nasby wrote:
> >Those two queries aren't the same. The first one can only return 0 or 1
> >rows;
> >the second one can return 0, 1, or 2 rows.
768)::int2;
> >>> else
> >>> return 0;
> >>> end if;
> >>>end
> >>>$$ language 'plpgsql';
> >
> >
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive
ot;rrs": found 0 removable, 7 nonremovable row versions in 1 pages
DETAIL: 0 dead row versions cannot be removed yet.
Nonremovable row versions range from 61 to 73 bytes long.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-23
FROM pg_sysviews.pg_user_tables
WHERE schema_name = 'schema'
AND table_name = 'table'
;
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.n
tion integration & imaging LLC
> 201 Linden Street : Third Floor
> Fort Collins, CO 80524
> 970-482-4400 voice
> 970-482-4499 fax
> www.i3.com
>
>
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervas
led book for optimizing PG queries?
8.1 can utilize multiple indexes per table.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-5
erhead to the system, I think that the previous
> methods don't create much overhead but if anyone have another idea of
> course it will also need to be efficent.
>
> Any new ideas or comments will be received gladly.
>
> Thanks in advance!
> Yonatan Ben-Nes
>
>
> Please correct me if I'm mistaken - I like being wrong ;)
No, you're right, but if you're not using connection pooling you clearly
don't care about performance anyway...
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pe
NULL
You might have to do the NULL check in a HAVING clause instead... try
it.
BTW, this is probably better asked on pgsql-sql.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive
101 - 200 of 647 matches
Mail list logo
