Hello,
Is any performance degree if I run PostgreSQL from cygwin on a Windows
XP machine?
thanks.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Jarek Lubczyn'ski wrote:
Hi, everybody,
Please help me with an urgent problem.
I have PostgreSQL version: 7.3.1Alfa1 for Windows (the only Win version available)
I am training installation of ProgreSQL on various PC's WinNT, 2K, XP and 2003
installed. In some cases I've got such a problem (till
(Running PG 7.3.4 on Sparc Solaris 9)
I have a Java application (which connects to Postgres using JDBC) which
I run from the Solaris box, but which I develop from my desktop PC. When
my application connects to Postgres, it can only obtain one connection.
i.e. if the server app is running, then my
On Thu, 2 Oct 2003, Kerv wrote:
> Hello,
>
> Is any performance degree if I run PostgreSQL from cygwin on a Windows
> XP machine?
Postgresql is known for poor performance in that situation. But it's
plenty good enough for pre-deployment testing and development.
---(e
Hi,
I would like to know how could
I do to get the host name from postgres.
Something like "CURRENT_HOSTNAME".
Thanx,
MAGO
_ IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí
Hi,
I would like to know how could
I do to get the host name from postgres.
Something like "CURRENT_HOSTNAME".
Thanx,
MAGO
--
NEU FÜR ALLE - GMX MediaCenter - für Fotos, Musik, Dateien...
Fotoalbum, File Sharing, MMS, Multimedia-Gruß, GMX FotoService
Jetzt kostenlos anmelden unte
Hi,
I am using a Postgres 7.2.1 db to store binary data as large objects
which users can add or delete as they need. I have found that without
frequent vacuums of the database the disk space used by the database
grows very quickly, as users on average add and delete binary objects of
about 160K at
Trying to dump and restore a production database with no success.
pg_dump database using the following:
pg_dump -v -b -C -Fc -U postgres -f servdb.tar.gz servdb
pg_restore with with following:
pg_restore -v -C -D template1 -Fc -U postgres servdb.tar.gz
restore fails with:
pg_restore: [archi
"Rob Long" <[EMAIL PROTECTED]> writes:
> Trying to dump and restore a production database with no success.
> pg_restore: [archiver (db)] could not execute query: ERROR: data type
> integer has no default operator class for access method "gist"
Hm, this is probably a matter of incorrect object res
Attached.
The previously posted index failure stated:
CREATE INDEX idx_disc_loc ON order_items USING gist (disc, loc);
However in this list it is:
CREATE INDEX idx_item_loc ON content_items USING gist (disclosuer, loc);
Rob
Tom Lane wrote:
> "Rob Long" <[EMAIL PROTECTED]> writes:
> > Trying to
As a starting point, check your free space map settings in the
postgresql.conf. They are low by default in 7.2.x.
free_space_relations* can safely be bumped to 1000. free_space_pages*
should probably be bumped to something like 5, though you might be
able to determine a better amount be seeing
On Thu, 2003-10-02 at 22:47, Marvin wrote:
> Because I would like to store in my table the name of the computer
> where the user saves the information.
>
> Whe have already into a MSSQL table the following definition:
>
> Field name TypeDefault
> IngUsernamenvarchar(50)
"Rob Long" <[EMAIL PROTECTED]> writes:
>>> Trying to dump and restore a production database with no success.
>>>
>>> pg_restore: [archiver (db)] could not execute query: ERROR: data type
>>> integer has no default operator class for access method "gist"
>>
>> Hm, this is probably a matter of inco
I made the changes you suggested and the usage was about the same
Initial after vacuum full
bash-2.05b# du -s -b /data/sql
57729024/data/sql
After 1st iteration
bash-2.05b# du -s -b /data/sql
57978880/data/sql
249856 byte increase
After 2nd iteration
bash-2.05b# du -s -b /data/s
"Chris White (cjwhite)" <[EMAIL PROTECTED]> writes:
> The index has grown by 4 pages and the table has grown by 10 pages. BTW,
> what is a page size? Why is this happening as this is the table that I
> am theoretically keeping the same size by adding/deleting the same
> objects from.
Kinda looks l
Anna Kanevsky wrote:
This is an almost embarrassing question, but I managed to delete all
rows out of one of the tables by making a little typo in the WHERE
statement.
When you do update or delete is good do it inside a transaction, I guess
you didn't !
I think that your datas are lost.
Gaetano
Tom,
You were right, 1 or 2 of the large objects weren't actually getting
removed from the table, each cycle. I wasn't running on a completely
empty database when I first started, so I didn't notice the undeleted
objects.
The program which interfaces to the database uses the JDBC method
LargeObje
On Tue, 30 Sep 2003, Anna Kanevsky wrote:
> This is an almost embarrassing question, but I managed to delete all rows
> out of one of the tables by making a little typo in the WHERE statement.
> Is there any way to restore these? the db was NOT vacuumed after that. but
> then, it wasn't backed up
No new messages on the newsgroup!
Somethink wrong ?
Gaetano Mendola
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get thr
19 matches
Mail list logo
