Title: Performance
And running postgresql on a P133 with 64 meggs of RAM using debian woody.
How many users will that box be able to serve?
I'm running apache/php on another machine and the database will have
questions and answers for some exams in it. Nothing hard, just text.
On Mon, 5 Feb 2001, [iso-8859-1] Johan Segernäs wrote:
> And running postgresql on a P133 with 64 meggs of RAM using debian woody.
> How many users will that box be able to serve?
>
> I'm running apache/php on another machine and the database will have
> questions and answers for some exams
Title: RE: [ADMIN] Performance
> On Mon, 5 Feb 2001, [iso-8859-1] Johan Segernäs wrote:
> > And running postgresql on a P133 with 64 meggs of RAM using
> debian woody.
> > How many users will that box be able to serve?
> >
> > I'm running apache/php on another machine and the database
> w
Hello:
I'm using postgresql v7.0.2, from RedHat 7.0 installation. How can I
configure it to use dates in european format? I used to put -o-e in the
execution of postmaster in /etc/rc.d/rc.init/postgresql, but now they
use a different program to start (pg_ctl):
su -l postgres -c "/usr/bin/pg_ctl
I think it will do.
I'm developing a web system based on PgSQL. My test
server is Cyrix 166MHz 16MB of RAM. My database has
few tables with over 1 milion rows and one of them has
almost 25 milions. With good indexes I can fetch data
form this table for less than 8-10 seconds.
But it depends on the
Hi guys,
I would like to know somethimg more specific for
indexes and clusters as far as I do not know very much
of R-TREES.
I have this situation:
create table gsc_act(
reg_id int2,
id int2,
ra int4,
de int4,
mag int2
);
This is a huge table approx 2GB cont
Hi there,
i have a little problem with one of my tables. can someone explain me how to
find that record?
vacuum says:
NOTICE: Rel mxaccounts: TID 226/18: OID IS INVALID. TUPGONE 0.
VACUUM
mxaccounts is my table, but how do i find the record causing this notice?
thanks in advance,
thomas
Salvador =?iso-8859-1?Q?Main=E9?= wrote:
>Hello:
>
>I'm using postgresql v7.0.2, from RedHat 7.0 installation. How can I
>configure it to use dates in european format? I used to put -o-e in the
>execution of postmaster in /etc/rc.d/rc.init/postgresql, but now they
>use a different prog
"Thomas Heller" <[EMAIL PROTECTED]> writes:
> vacuum says:
> NOTICE: Rel mxaccounts: TID 226/18: OID IS INVALID. TUPGONE 0.
> VACUUM
> mxaccounts is my table, but how do i find the record causing this notice?
Well, it's telling you the TID. Try
select * from mxaccounts where ctid = '(
The current source (7.1 beta 4, I think) has support for outer joins and they work
great!
-Original Message-
From: Steve Doerr [SMTP:[EMAIL PROTECTED]]
Sent: Saturday, February 03, 2001 7:37 PM
To: [EMAIL PROTECTED]
Subject:Outer Joins
I saw that outer joins will be supp
We made a separate web page for the long version.
> Bruce Momjian writes :
>
> > Can I get some feedback from the group? Should a long or short version
> > be used in the FAQ?
>
> Please keep the long version in the FAQ at least until the full
> version makes its way into the docs...
>
> Kim
We want to install the client at Windows
machine. We had downloaded the pgadmin and installed in in windows2000
machine through windows installer. But we could not configure the DSN and
get going. kindly help by pointing further documentation
Regards,
T.G.Sekhar,
Raghav Infotech Limite
Hello, I have the problem:
There is server with directory size quotes for users and user's access to his
own Postgres database. Problem: every user can use unlimited disc
space by creating objects in his database. How can i limit size of
each database? I think, it's very useful thing, but i haven'
hallo newsgroup,
I am looking for information about index- and query-tuning for postgres. any
hint, link or book-recomendation highly appreciated.
thanks
Micha
(postgres version is 7.0.2 if important)
I have installed NT4.0 , Option Pack 3, I.E.4.01 , Service Pack4 ,
I.E.5.0,
Service Pack 5 and then I tried to install SQL 7.0 .
The message I received from setup is : "Installation of Microsoft Management
Console has failed".
And then a message from Dr Watson is followed:
"An application error
Help pls.
Our operator deleted pg_log. Questions are:
What to do?
Where can I find the structure of postgre files?
For those who would like to design DB with UML schema into Together
(commercial product !), I've written a config file that enable you
to export your schema in sql (DDL) and import from a postgres DB
into an UML schema.
You'll find everything at: http://lbdpc15.epfl.ch/ ...
Ph.R.
_
Michael,
You might try posting to one of the MS message boards. This board is for a
different database, postgreSQL. It is usually implemented in Linux/Unix and it
is open source. My suggestion would be for you to get a *nix box and run
Oracle.
Michael wrote:
> I have installed NT4.0 , Opti
I'm using Conectiva Linux 6.0, Postgresql 7.0.2.
In my scrypt, I start with default mode. But I think it is util
for you:
daemon --check postmaster --user postgres "export
PGDATESTYLE='Postgres'; /usr/bin/postmaster -o -e -i -S -D/var/lib/pgsql"
On Mon, 5 Feb 2001,
Hi,
We are an ISP running our radius on postgres version 7.0.2 on an twin Intel
550 processor
with Solaris 7 and 600Mb RAM :
1. We have a database with 8 tables one of these tables (TABLE1) gets
updated every second or so as a result the table keeps growing and growing
and growing... to about 5
full release is planned for end February, if all goes well ...
On Sat, 3 Feb 2001, Steve Doerr wrote:
> I saw that outer joins will be supported in ver. 7.1. Does anyone know
> when this is expected, or if there is beta support for them currently?
>
> Thanks,
> Steve
>
>
Marc G. Fournier
Hello, I need some information by you about PosgreSQL on Solaris
I have found binaries of client but not of server where can I find it ?
Best regards, Gianluigi
Hello all,
I am running PostgreSQL-7.0.3. I changed the value of BLCKSZ (in
"include/config.h" to 16384, recompiled and reinstalled the sources. After
having restarted the backend I tried to create a table with three
varchar(5000)-columns and tried to add three character-values with each 4000
cha
Hello all
How do I set up (config) the syslog.conf in red hat 7.0 so that I can
capture the log of other machine ?? Is there any additional works needed to
do ??
Thanks
Sum
> -Original Message-
> From: Michael Miyabara-McCaskey [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, January 31, 2
hi,i'm sorry but
i don't speak english...but i have a problem:
ERROR:cannot read block 9053 of mots
i do:
$ vacuumdb -v --table 'mots' moteur
NOTICE: --Relation mots--
ERROR: cannot read block 9053 of mots
vacuumdb: database vacuum failed on moteur.
so..
moteur=> VACUUM
moteur-> ;
pq
Hi,
Anybody knows about
PostGreSQL available for Windows 95/98.
Thanks,
Vijay
26 matches
Mail list logo
