[SQL] hardware information

2009-09-16 Thread std pik
Hello all.. I'm using PostgreSQL 8.3.. How can I get information about the hardware utilization: - CPU usage. - Disk space. - Memory allocation. thank you. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresq

Re: [SQL] hardware information

2009-09-16 Thread Martie Krukkeland
top ?? "std pik" schreef in bericht news:80e9c801-4609-49c5-8bc8-d19e08cca...@33g2000vbe.googlegroups.com... > Hello all.. > I'm using PostgreSQL 8.3.. > How can I get information about the hardware utilization: > - CPU usage. > - Disk space. > - Memory allocation. > thank you.

Re: [SQL] ordered by join? ranked aggregate? how to?

2009-09-16 Thread wstrzalka
On 15 Wrz, 10:10, wstrzalka wrote: > On 15 Wrz, 09:56, andreas.kretsch...@schollglas.com ("A. Kretschmer") > wrote: > > > > > In response to wstrzalka : > > > > What I need is to join 2 tables > > > > CREATE TABLE master( > > >     id INT4 > > > ); > > > > CREATE TABLE slave ( > > >     master_id

Re: [SQL] hardware information

2009-09-16 Thread Psicopunk
On Sep 15, 3:38 pm, "Martie Krukkeland" wrote: > top ?? > > "std pik" schreef in > berichtnews:80e9c801-4609-49c5-8bc8-d19e08cca...@33g2000vbe.googlegroups.com... > > > > > Hello all.. > > I'm using PostgreSQL 8.3.. > > How can I get information about the hardware utilization: > >       - CPU us

Re: [SQL] ordered by join? ranked aggregate? how to?

2009-09-16 Thread wstrzalka
On 15 Wrz, 09:56, andreas.kretsch...@schollglas.com ("A. Kretschmer") wrote: > In response to wstrzalka : > > > > > What I need is to join 2 tables > > > CREATE TABLE master( > >     id INT4 > > ); > > > CREATE TABLE slave ( > >     master_id INT4, > >     rank INT4, > >     value TEXT); > > > What

[SQL] CREATE INDEX on column of type 'point'

2009-09-16 Thread Mario Splivalo
As I have discovered, there is no way to just create index on a column of type 'point' - postgres complains about not knowing the default operator class, no matter what index type I use. Now, my table looks like this: CREATE TABLE places ( place_id integer primary key, coordina