On Tue, Sep 26, 2006 at 12:18:31PM +1000, GURON Rawender wrote:
> I am new to PostgreSQL and have long experience of administering Oracle
> database. I am looking for user sessions information in a PostgreSQL.
> Basically I am after dynamic performance views equivalent to Oracle's
> v$session, v$pr
Hi do you can search in:http://www.postgresql.org/docs/8.1/interactive/catalogs.htmlHere you go learning how thats information are stored.
[],sMarcelo.2006/9/25, GURON Rawender <[EMAIL PROTECTED]>:
I am new to
PostgreSQL and have long experience of administering Oracle database. I am
looking
I am new to
PostgreSQL and have long experience of administering Oracle database. I am
looking for user sessions information in a PostgreSQL. Basically I am after
dynamic performance views equivalent to Oracle's v$session, v$process,
v$session_wait etc. Can someone guide me in right directio
August Zajonc <[EMAIL PROTECTED]> writes:
> The reason this is interesting to me is that for me, instrumentation
> really seemed like a core thing that one would want in a database.
AFAICS, contrib/adminpack has approximately nothing to do with
"instrumentation".
regards,
Joshua D. Drake wrote:
> August Zajonc wrote:
>> Guillaume Lelarge wrote:
>>> Jim Nasby a ecrit le 22/09/2006 04:52:
On Sep 21, 2006, at 1:53 PM, Thomas Vatter wrote:
> When connection to the server with pgadmin3 there is a warning:
> "The server lacks instrumentation functions ..."
>>
August Zajonc wrote:
Guillaume Lelarge wrote:
Jim Nasby a ecrit le 22/09/2006 04:52:
On Sep 21, 2006, at 1:53 PM, Thomas Vatter wrote:
When connection to the server with pgadmin3 there is a warning:
"The server lacks instrumentation functions ..."
There may be something wrong with my installat
Hi Tom,
Further to my request below, the following recommendation exists in the Postgres 8.1 documentation:-
http://www.postgresql.org/docs/8.1/interactive/routine-reindex.html
On 9/25/06, adey <[EMAIL PROTECTED]> wrote:
Thanks Tom.
How does Postgres handle page splits and redirections in inde
Note that PostgreSQL doesn't auto-update clustered indexes. i.e. they
deteriorate over time, and require being re-clustered after a while.
On Mon, 2006-09-25 at 17:27, adey wrote:
> A good guide for a clustered index is:-
> Will the index be unique, static and narrow.
> If not, avoid clustered in
Guillaume Lelarge wrote:
> Jim Nasby a ecrit le 22/09/2006 04:52:
>> On Sep 21, 2006, at 1:53 PM, Thomas Vatter wrote:
>>> When connection to the server with pgadmin3 there is a warning:
>>> "The server lacks instrumentation functions ..."
>>> There may be something wrong with my installation.
>>>
A good guide for a clustered index is:-
Will the index be unique, static and narrow.
If not, avoid clustered indexing as they require extra work on disk to maintain their sequence.
On 9/26/06, Chris Hoover <[EMAIL PROTECTED]> wrote:
I am looking to squeeze a bit more speed out of my database by cl
I am looking to squeeze a bit more speed out of my database by clustering most of my tables. However, on tables with multiple indexes, how is the best way to choose the index. I am thinking I want to use the index with the largest pg_stat_user_indexes.idx_tup_read. Would this be correct? If not
Please unsubscribe
me! Thank you!
All the best,
Tom
Thomas F. Kelley, CPA
On Sep 25, 2006, at 6:43 AM, Guido Neitzer wrote:
Hi.
On 9/25/06, Jim Nasby <[EMAIL PROTECTED]> wrote:
As for hardware, until recently, AMD was the un-disputed king when it
came to running PostgreSQL (and databases in general). But the newer
Intel CPUs seem to have surpassed the Opteron. I b
[EMAIL PROTECTED] ("Joshua D. Drake") writes:
> Scott Marlowe wrote:
>> On Sun, 2006-09-24 at 20:18 -0400, Jim Nasby wrote:
>>> On Sep 22, 2006, at 6:12 PM, Raul Retamozo wrote:
Hi everyone on the list. I want to know what is the reccommended
OS to work with PostgreSQL , on specific wit
Hi
I request you to please unsubscribe this email address from your mailing list
Thank you
Ray Stell wrote:
I'm curious about the "[ADMIN] COPY FROM command v8.1.4" thread
as it applies to this thread.The COPY thread pointed to kernel
issues in x86_64 GNU/Linux SLES 9. I'm wondering if x86_64 is not
a good move for pg servers at this time. Are there happy x86_64
production deplo
Much more important is your disk subsystem. Using an Areca RAID
controller with battery backed cache and a half dozen or more hard
drives is often the real winner for performance.
Yes, LSI and 3Ware are also good. I am particularly fond of LSI but
Areca has PCI-Express cards which means you ca
On Mon, 2006-09-25 at 10:41, Srinivas Lakshmi Sistla wrote:
> Guys,
>
> I am new to Postgresql. We have a database on Linux box and users
> complaining about queries running very slow. I tried to run vacuum
> this moring but it doesn't seem to do anything. I logged on to
> database by typing psql
On Mon, 2006-09-25 at 10:28, Joshua D. Drake wrote:
> Scott Marlowe wrote:
> > On Sun, 2006-09-24 at 20:18 -0400, Jim Nasby wrote:
> >> On Sep 22, 2006, at 6:12 PM, Raul Retamozo wrote:
> >>> Hi everyone on the list. I want to know what is the reccommended OS
> >>> to work with PostgreSQL , on sp
Guys,
I am new to Postgresql. We have a database
on Linux box and users complaining about queries running very slow. I tried
to run vacuum this moring but it doesn't seem to do anything. I logged
on to database by typing psql bhpbprod (bhpbprod is database name)
and that gave me the prompt bhpbp
Scott Marlowe wrote:
On Sun, 2006-09-24 at 20:18 -0400, Jim Nasby wrote:
On Sep 22, 2006, at 6:12 PM, Raul Retamozo wrote:
Hi everyone on the list. I want to know what is the reccommended OS
to work with PostgreSQL , on specific with PostGIS:
One more question is about what HW (server) offers
hi,
yep :~)
compiled from source on Suse 9.2 (not SLES 9)
best regards
Hakan
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Ray Stell
> Sent: Monday, September 25, 2006 5:03 PM
> To: Scott Marlowe
> Cc: Jim Nasby; Raul Retamozo; pgsql-admin@
I'm curious about the "[ADMIN] COPY FROM command v8.1.4" thread
as it applies to this thread.The COPY thread pointed to kernel
issues in x86_64 GNU/Linux SLES 9. I'm wondering if x86_64 is not
a good move for pg servers at this time. Are there happy x86_64
production deployments?
On Mon,
On Sun, 2006-09-24 at 20:18 -0400, Jim Nasby wrote:
> On Sep 22, 2006, at 6:12 PM, Raul Retamozo wrote:
> > Hi everyone on the list. I want to know what is the reccommended OS
> > to work with PostgreSQL , on specific with PostGIS:
> > One more question is about what HW (server) offers the best
24 matches
Mail list logo
