Scott Marlowe wrote:
On Sat, 2004-10-02 at 09:14, Stephan Szabo wrote:
On Fri, 1 Oct 2004, Scott Marlowe wrote:
On Fri, 2004-10-01 at 14:26, Shane | SkinnyCorp wrote:
Okay, just so no one posts about this again...
the 'ORDER BY t.status=5,lastreply' clause is meant to float the threads
with a stat
Hi
I am working on a real time
application.I have a table which has 1 rows and 31 columns.It is updated
every 5 secs.But only a max of 5000 rows may be updated.And Updates effect only
about 10 columns.The postgresql.conf file is given below.I donot know
what values the parameters should ta
William Yu wrote:
Shane | SkinnyCorp wrote:
I would like to also add that I've been a sysadmin for quite some
time, and
I've been designing databases for quite some time as well. I'm no
idiot, I
just can't find the bottleneck here (if one does in fact exist). So in
light
of this, please send me
Sounds like all you need to do is to check what keys your app needs on
the tables and then ensure that you have these set up.
There is no way that MySQL will be faster than PG... seems like your
MySQL DB was optimised and your PG wasn't.
Should be very easy and quick to sort out.
Brad
Shane | Sk
Michael Long <[EMAIL PROTECTED]> writes:
> The when configuring 8.0b3 I thought that I had specified to use the
> rpath style link, although now that I look at the string again, maybe not :)
> ./configure --prefix=/usr/local/pgsql_8.0b3 --disable-rpath
Looks like not ...
> How do I go about so
On Sun, 3 Oct 2004, Gaetano Mendola wrote:
> Scott Marlowe wrote:
> > On Sat, 2004-10-02 at 09:14, Stephan Szabo wrote:
> >
> >>On Fri, 1 Oct 2004, Scott Marlowe wrote:
> >>
> >>
> >>>On Fri, 2004-10-01 at 14:26, Shane | SkinnyCorp wrote:
> >>>
> Okay, just so no one posts about this again...
I would recommend "make distclean", reconfigure, rebuild whenever you
change configure arguments. That's the only way to be really sure the
changes propagate to everywhere they need to.
Tom, I followed your recommendation and rebuilt postgres after doing
"make distclean". I still get the foll
Quoting Michael Long <[EMAIL PROTECTED]>:
>
> ./psql template1
> ./psql: relocation error: ./psql: undefined symbol: PQsetErrorVerbosity
>
> Is psql linked to the proper libraries?
>
> --This is version 7.3.2
Below looks okay.
> ldd /usr/bin/psql
> libpq.so.3 => /usr/lib/libpq.so.3 (0x40
Michael Long <[EMAIL PROTECTED]> writes:
> ./psql template1
> ./psql: relocation error: ./psql: undefined symbol: PQsetErrorVerbosity
> Is psql linked to the proper libraries?
> ldd /usr/local/pgsql_8.0b3/bin/psql
> libpq.so.3 => /usr/lib/libpq.so.3 (0x40025000)
Obviously not :-(. This
Are there any updates/deleteed/adding to the db?What
did help you ?Are you using transactions?
> gain in performance. All of my optimizations seem to help at first, but
> everything soon gets just as slow as it was before... and I mean SLOW.
>
--
Evgeny.
---(end of bro
On Fri, 1 Oct 2004, Kris Kiger wrote:
> Hey all, its me again. If I do not do a count(product_id) on my
> tsearch2 queries, its actually really fast, for example;
>
Hmm, I also really want to know what's the difference ?
Postgresql 8.0beta3 on Linux 2.4.25
tsearchd=# explain analyze select bod
>> Hey all, its me again. If I do not do a count(product_id) on my
>> tsearch2 queries, its actually really fast, for example;
>>
>
>Hmm, I also really want to know what's the difference ?
>Postgresql 8.0beta3 on Linux 2.4.25
>
>tsearchd=# explain analyze select body from txt where
>fts_index @@
Magnus
On Sun, 3 Oct 2004, Magnus Hagander wrote:
> >> Hey all, its me again. If I do not do a count(product_id) on my
> >> tsearch2 queries, its actually really fast, for example;
> >>
> >
> >Hmm, I also really want to know what's the difference ?
> >Postgresql 8.0beta3 on Linux 2.4.25
> >
>
13 matches
Mail list logo
