Nirmal Kumar wrote:
Hi
We are facing a slowness problem in posgres Database.
Whenver we query a data it is very very slow.It is
running on the IBM ISERIES I5 Server.
HARDWARE: IBM Iseries I5 PPC Server
OS: SUSE LINUX ENTERPRISE SERVER 9.0
POSTGRESSQL: 7.4.2
WEB SERVER: APACHE2
Using the comm
Vinod,
How about a copy/paste of the exact error message?
On Sat, 19 Nov 2005, [EMAIL PROTECTED] wrote:
BlankHii,
This is vinod DBA in HTC GLOBAL SERVICES ..we have a small issue in running
batch files to load data ..I have pasted the script which I am trying to
execute it's is constantly f
What is the explain analyze output of the query which is slow? What does your
data look like? What's your postgresql.conf look like?
On Mon, 21 Nov 2005, Nirmal Kumar wrote:
Hi
We are facing a slowness problem in posgres Database.
Whenver we query a data it is very very slow.It is
running
Way overkill... all you really need is a decently sized (160G or a pair of
80's) hard-disk and a P-III / AMD Athlon 750 MHz with 512MB Ram and FreeBSD
5 and postgreSQL
With databases... it's all about disk-performance anyway...
""Michael D. Sofka"" <[EMAIL PROTECTED]> wrote in message
ne
Well, what's psql -U vinodsr vinodsr show?
You should take a look at
http://www.postgresql.org/docs/8.1/interactive/client-authentication.html
On Sat, Nov 19, 2005 at 04:36:04PM +0530, [EMAIL PROTECTED] wrote:
> BlankHii,
>
> This is vinod DBA in HTC GLOBAL SERVICES ..we have a small issue in r
On Thu, Nov 17, 2005 at 07:56:21PM +0100, Magnus Hagander wrote:
> The way I read it, a delay should help. It's basically running out of
> kernel buffers, and we just delay, somebody else (another process, or an
> IRQ handler, or whatever) should get finished with their I/O, free up
> the buffer, a
How about the output from explain analyze on one of the slow queries?
On Mon, Nov 21, 2005 at 07:04:29AM -0800, Nirmal Kumar wrote:
> Hi
>
> We are facing a slowness problem in posgres Database.
> Whenver we query a data it is very very slow.It is
> running on the IBM ISERIES I5 Server.
>
> HAR
On Mon, Nov 21, 2005 at 09:41:36AM -0500, Michael D. Sofka wrote:
> >I suggest looking at your current bottleneck first.
> >It's likely to be the most cost-efficient route out.
>
> I/O is our bottleneck. The machine is not CPU loaded. And, in fact,
> our current performance is good. The machine
On Mon, Nov 21, 2005 at 10:34:36AM +0100, Mario Splivalo wrote:
> > RAID5 generally doesn't make for a fast database. The problem is that
> > there is a huge amount of overhead everytime you go to write something
> > out to a RAID5 array. With careful tuning of the background writer you
> > might b
On 11/21/05, Nirmal Kumar <[EMAIL PROTECTED]> wrote:
> Hi
>
> We are facing a slowness problem in posgres Database.
> Whenver we query a data it is very very slow.It is
> running on the IBM ISERIES I5 Server.
>
> HARDWARE: IBM Iseries I5 PPC Server
> OS: SUSE LINUX ENTERPRISE SERVER 9.0
> POSTGRESS
Marcin Giedz wrote:
> Dnia poniedzia??ek, 21 listopada 2005 16:31, Alvaro Herrera napisa??:
> > Marcin Giedz wrote:
> > > Dnia poniedzia??ek, 21 listopada 2005 11:23, Mario Splivalo napisa??:
> > > > Cool! :) Could you give specs on processors itself? The clock, cache,
> > > > and stuff?
> > >
> >
Joshua Marsh wrote:
Does/Can the index track each element in the array, or does it track
only the array as a whole?
Built in index support works on the array as a whole, not the individual
elements.
How can I increase the speed of a query like: SELECT * FROM table WHERE
123 = ANY(array_of_
Hi
We are facing a slowness problem in posgres Database.
Whenver we query a data it is very very slow.It is
running on the IBM ISERIES I5 Server.
HARDWARE: IBM Iseries I5 PPC Server
OS: SUSE LINUX ENTERPRISE SERVER 9.0
POSTGRESSQL: 7.4.2
WEB SERVER: APACHE2
Using the command line also it is tak
Hii,
This is vinod DBA in HTC GLOBAL SERVICES ..we have a small issue in
running batch files to load data ..I have pasted the script which I am trying to
execute it's is constantly failing with an authentication failure
psql -U vinodsr vinodsr <
C:\MU\BP_BUSINESS_PARTNER_PARTY.datpsql
--On Saturday, November 19, 2005 12:15:46 AM + John Jensen <[EMAIL PROTECTED]>
wrote:
What you describe is a real-time system. Does your
requirements call for real-time performance ?
Remember that performance from memory is much more
expensive than disk i/o (at least up to a certain point).
I've been searching the manual looking for information about the
effects of indexing an array column but haven't found any information
as of yet.
Does anyone have any information on how the indexes work for arrayed columns?
Does/Can the index track each element in the array, or does it track
Dnia poniedziałek, 21 listopada 2005 16:31, Alvaro Herrera napisał:
> Marcin Giedz wrote:
> > Dnia poniedzia??ek, 21 listopada 2005 11:23, Mario Splivalo napisa??:
> > > Cool! :) Could you give specs on processors itself? The clock, cache,
> > > and stuff?
> >
> > Look at this site once again - mad
Marcin Giedz wrote:
> Dnia poniedzia??ek, 21 listopada 2005 11:23, Mario Splivalo napisa??:
> > Cool! :) Could you give specs on processors itself? The clock, cache,
> > and stuff?
>
> Look at this site once again - made some additional info.
It says you have "2 x Opteron Dual Core" -- so is it
Olive,
You must compile from source, as Mike has mentioned; 8.0.1 is not
certified on Solaris 10, and you must limit your functionality. If you
can at least try 8.0.3, please do so. If you compile from source, check
your gcc version. It must be at least as recent as that recommended in
the release
Dnia poniedziałek, 21 listopada 2005 11:23, Mario Splivalo napisał:
> On Mon, 2005-11-21 at 10:58 +0100, Marcin Giedz wrote:
> > Dnia poniedziałek, 21 listopada 2005 10:34, Mario Splivalo napisał:
> > > On Sun, 2005-11-20 at 11:53 -0600, Jim C. Nasby wrote:
> > > > Two general comments: most people
On Mon, 2005-11-21 at 10:58 +0100, Marcin Giedz wrote:
> Dnia poniedziałek, 21 listopada 2005 10:34, Mario Splivalo napisał:
> > On Sun, 2005-11-20 at 11:53 -0600, Jim C. Nasby wrote:
> > > Two general comments: most people find that Opterons perform much better
> > > than Xeons. With some versions
Dnia poniedziałek, 21 listopada 2005 10:34, Mario Splivalo napisał:
> On Sun, 2005-11-20 at 11:53 -0600, Jim C. Nasby wrote:
> > Two general comments: most people find that Opterons perform much better
> > than Xeons. With some versions of PostgreSQL, the difference is over
> > 50%.
>
> Could you b
On Sun, 2005-11-20 at 22:05 -0800, Gary Hoffman wrote:
> I've run PHP and PostgreSQL for quite a while and never seen this problem
> before. I think it's new, but maybe I never paid attention to it before.
>
> I am frequently running out of connections to the database. Here's a
> snippet of my ps
Did you download the source or precompiled binary? It seems to me that
either you don't have libreadline.so.4 installed on your system, or your
LD_LIBRARY_PATH is not pointing to the right place.
Neverthenless, on my system, I have it like this:
[flyb] [/tmp/majk/postgresql-8.1.0] 2 > locate libr
On Sun, 2005-11-20 at 11:53 -0600, Jim C. Nasby wrote:
> Two general comments: most people find that Opterons perform much better
> than Xeons. With some versions of PostgreSQL, the difference is over
> 50%.
Could you be more specific on that? Which version of Postgres perform
better on Opteron th
I've run PHP and PostgreSQL for quite a while and never seen this problem
before. I think it's new, but maybe I never paid attention to it before.
I am frequently running out of connections to the database. Here's a
snippet of my ps -ax
1882 ?? S 0:00.07 postgres: postgres cgssd_members
26 matches
Mail list logo
