[GENERAL] Fwd: idea for big speed optimization

-- Forwarded message -- From: Андрей Брюхов Date: 2016-12-22 17:08 GMT+03:00 Subject: idea for big speed optimization To: jdr...@postgresql.org Hello! Can Postgres Organization use free super optimizaing C compiler for compile postgres (advenced builds) ? https://www.pgroup.com

Re: [GENERAL] enable SSL on server

Richard Huxton wrote: Andrei wrote: Hello! Please tell - how to enable SSL on PostgreSQL 8.1 server. When setting option "ssl = on" in postgresql.conf - server even doesn't want to startup. I'm using PostgreSQL 8.1 on Windows 2000, installed from .msi, downloaded from www.posgtresql.

[GENERAL] enable SSL on server

Hello! Please tell - how to enable SSL on PostgreSQL 8.1 server. When setting option "ssl = on" in postgresql.conf - server even doesn't want to startup. I'm using PostgreSQL 8.1 on Windows 2000, installed from .msi, downloaded from www.posgtresql.org.

[GENERAL] client_encoding values

Hello! Please, help. I need to get complete list of 'client_encoding' values supported by the PostgreSQL Server. Can I somehow get these values using select query or function call? Best regards, Kovalevski Andr

[GENERAL] 8.1 removed functions

Hello! Can someone answer - why in PostgreSQL 8.1 have been removed such functions as 'makeaclitem(...)' and 'information_schema.pg_keypositions()'. Are there any similar functions now and where can I find the list of all deprecated functions?

[GENERAL] How to check is the table system

Hello! How can I get table's comment, created like this: COMMENT ON TABLE people IS '...comment...' ? What system table keeps comments on databases, schemas and tables? Big Thanks, Andrei ---(end of broadcast)--- TIP 5: don't forget

Re: [GENERAL] [Re] wrong protocol sequence?

John DeSoi wrote: On Sep 22, 2005, at 10:11 AM, Андрей wrote: I'm sending such messages to server in native postgresql protocol: 'Parse' -> 'Describe' -> 'Sync' (get: 'Parse Complete' and 'Ready For Query' messages bac

[GENERAL] wrong protocol sequence?

Hello! I'm sending such messages to server in native postgresql protocol: 'Parse' -> 'Describe' -> 'Sync' (get: 'Parse Complete' and 'Ready For Query' messages back). But when the sequence became: 'Parse' -> 'Sync' (get: 'Parse Complete' and 'Ready For Query' messages back), little pause, '

[GENERAL] How to check is the table system

Hello! In what way can I determine is the table system? ODBC driver does it by checking table name's prefix: if it begins with 'pg_' - driver desides that the table is system, but that's a bad idea. I can create table and call it 'pg_mytable', but it won't become system! Big Thanks,

[GENERAL] cursors problem

Hi! Is there any possibility to get the number of rows resulted by SELECT CURSOR? Best Regards, Andrei. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate s