Ruslan A Dautkhanov <[EMAIL PROTECTED]> writes:
> I have problem in PG performance - all database caches is allocated
> to one table, which is much greater than all other tables together, but
> requests to this huge table much rarely, than requests with
> other tables.
What makes y
Hi,
I have problem in PG performance - all database caches is allocated
to one table, which is much greater than all other tables together, but
requests to this huge table much rarely, than requests with other tables.
How can I adjust which tables should be cached more (cache r
Michael Conn wrote:
> Is postgreSQL ODBC compliant? Will it operate with MS Windows 2000 or NT?
>
> Your assistance with this questions would be greatly appreciated.
Not sure how compliant we are, but we do communicate with clients
running MS software just fine.
--
Bruce Momjian
I found that PAM authentication in 7.2.3 doesn't appear to work
properly. It appeared to me that the server wasn't waiting for
the PAM conversation to complete before it rejected the request,
so I did a little rewrite on the auth.c file to sort of force
things to prompt for a password and then sho
On Mon, 28 Oct 2002 [EMAIL PROTECTED] wrote:
> Lynn Tilby ([EMAIL PROTECTED]) reports a bug with a severity of 1
> The lower the number the more severe it is.
>
> Short Description
> create function failing... ERROR: stat failed on file '
>
> Long Description
> DEBUG: ProcessUtility: create func
Lynn Tilby ([EMAIL PROTECTED]) reports a bug with a severity of 1
The lower the number the more severe it is.
Short Description
create function failing... ERROR: stat failed on file '
Long Description
DEBUG: ProcessUtility: create function dys_btwn_dates ( date , date ) returns int
as '
Jeff Boes <[EMAIL PROTECTED]> writes:
> The "VACUUM ANALYZE tablename" command does not have the same effect on
> table metadata under 7.2.1 and 7.2.3. In particular, I've noted that
> pg_class.reltuples is not updated by vacuuming after a delete.
Hard to believe ... I see no changes in the 7.2
Hallo!
I have a problem with BeOS and PostgreSQL7.2.1 with BONE.
The follow error is comming.
$ createdb db01
psql: could not create socket: Address family not supported by protocol
family
createdb: database creation failed
Please help me.
---(end of broadcast)
Is postgreSQL ODBC compliant? Will it operate with MS Windows 2000 or NT?
Your assistance with this questions would be greatly appreciated.
Cheers,
Michael
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.post
I am selecting rows from a table using "select *
from gla where glacode = $glresult[0]"
$glresult[0] comes from a previous query
result.
For the first three rows in the table I get the
error "Warning: Unable to jump to row 0 on PostgreSQL result index 4 in
/home/httpd/infocus/html/iris/ben_g
$ createlang --pglib=/usr/local/pgsql/lib plpgsql template1
ERROR: Load of file /usr/local/pgsql/lib/plpgsql.so failed: ld.so.1:
/usr/local/pgsql/bin/postmaster: errore fatale:libgcc_s.so.1: impossibile
aprire: File o directory non trovati
createlang: language installation failed
$
The "VACUUM ANALYZE tablename" command does not have the same effect on
table metadata under 7.2.1 and 7.2.3. In particular, I've noted that
pg_class.reltuples is not updated by vacuuming after a delete.
Here is a sequence of SQL commands to demonstrate the difference. Under
7.2.1, the result
Tom Lane wrote:
>
> Nicolaus Erichsen <[EMAIL PROTECTED]> writes:
> > I recently found a problem with sorting german 'Umlaute' .
>
> Sounds like you did not set the right locale when creating
> the database.
> You need to be careful to run initdb with LANG (or LC_ALL or at least
> LC_COLLATE) set
Hi Tom!
Thank you for your reply.
> > Is this bug fixed in 7.2.3?
>
> Try it and see.
>
I tried it on another box (RedHat Linux 8.0, much faster and
newer than the OpenBSD box) and it took 2000 seconds (10 times
faster than the 7.1.3 on the slower OpenBSD box).
Btw: MySQL on the slower box is ab
14 matches
Mail list logo
