Re: [HACKERS] todo: Hash index creation

Ühel kenal päeval, E, 2007-07-02 kell 04:27, kirjutas Naz Gassiep: I've been warned away from hash indexes before, however I had no idea that it's performance was that abysmal that BTREE beat it and I was definitely not aware that they were not included in WAL logs. I was told it wasn't as

Re: [HACKERS] tsearch in core patch

Ühel kenal päeval, N, 2007-06-21 kell 21:44, kirjutas Teodor Sigaev: http://www.sigaev.ru/misc/tsearch_core-0.52.gz Plan was: 1) rename FULLTEXT to TEXT SEARCH in SQL command done 2) rework Snowball stemmer's as Tom suggested done 3) ALTER FULLTEXT CONFIGURATION cfgname

Re: [HACKERS] Selecting a constant question

Ühel kenal päeval, E, 2007-06-11 kell 22:55, kirjutas Dann Corbit: -Original Message- ... I hope someone who truly understands database interfaces will read this thread and address the issue. For now we will have to special case postgres in our application until it is

Re: [HACKERS] Selecting a constant question

Ühel kenal päeval, T, 2007-06-12 kell 13:40, kirjutas Larry McGhaw: For what its worth .. Your statement about why we are the first people to mention this problem really got me thinking. Anyone who would attempt to write an ODBC driver for Postgres would run into the exact same issue. So I

Re: [HACKERS] Selecting a constant question

Ühel kenal päeval, E, 2007-06-11 kell 13:38, kirjutas Dann Corbit: -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Monday, June 11, 2007 1:32 PM To: Dann Corbit Cc: Gregory Stark; pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Selecting a constant

Re: [HACKERS] Selecting a constant question

Ühel kenal päeval, E, 2007-06-11 kell 22:11, kirjutas Larry McGhaw: As far as I am aware these statements are true. If you have a specific example you could provide to the contrary that would be interesting. Even if there are such conditions it does not change the fact that libpq and/or

Re: [HACKERS] Controlling Load Distributed Checkpoints

to things outside postgres, so learning to understand it takes time. Having the knows available helps as more people ar willing to do turn-the-knobs-and-test vs. recompile-and-test. Perhaps what we need is to think about how it can auto-tune itself. Sure. --- Hannu Krosing

Re: [HACKERS] ERROR: index row size 2960 exceeds btree maximum

Ühel kenal päeval, K, 2007-05-30 kell 21:41, kirjutas Rodrigo Sakai: Hello, I’m developing an application that needs a different data type. So, I have implemented this new data type inside postgresql using C, as documentation shows to. Basically, the data type is a

Re: [HACKERS] status of PlPython

Ühel kenal päeval, E, 2007-05-28 kell 20:57, kirjutas [EMAIL PROTECTED]: I wonder if I should use PlPython in my projects or not. Browsing on the Python list it seems that nobody is using it. At least we are usingi it at Skype. Browsing on Google Groups I find worrysome threads talking

Re: [HACKERS] plperl vs. bytea

Ühel kenal päeval, E, 2007-05-07 kell 13:57, kirjutas Andrew Dunstan: Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: Tino Wildenhain wrote: Andrew Dunstan schrieb: This does not need to be over-engineered, IMNSHO. Well could you explain where

[HACKERS] EXPLAIN/EXPLAIN ANALYSE for pl/pgsql functions

How much effort would it be to add EXPLAIN/EXPLAIN ANALYSE capability to pl/pgsql functions? what I mean, is either a special mode, where SELECT my_plpgsql_func() would print all query plans instead or in addition to executing them, or some way for EXPLAIN to pass some flags to functions so that

Re: [PATCHES] [HACKERS] Full page writes improvement, code update

perhaps from better disk cache usage. For me pg_compresslog seems to be a winner even if it just does not degrade performance. -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http

Re: [HACKERS] Query

the PostgreSQL project by donating at http://www.postgresql.org/about/donate -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com

Re: [HACKERS] Feature thought: idle in transaction timeout

happening; cave and implement it. We should reserve the name for the behavior that people would expect a parameter named like that to have. Agreed. Sincerely, Joshua D. Drake regards, tom lane -- Hannu Krosing Database Architect Skype

Re: [HACKERS] Proposal: include PL/Proxy into core

.) -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project

Re: [HACKERS] notification payloads

room in shared memory buffer. Alas, I have lost my design 3 a4 pages of design notes for organising things in fixed-size buffer, but the basic operation data-wise sould be as in attached sql file. -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F

Re: [HACKERS] notification payloads

Ühel kenal päeval, T, 2007-03-27 kell 11:17, kirjutas Hannu Krosing: Ühel kenal päeval, E, 2007-03-26 kell 11:30, kirjutas Andrew Dunstan: This feature (ability to add a message payload to a NOTIFY) is on the TODO list and I had undertaken to implement it. However, pressure of other work

Re: [HACKERS] notification payloads

Ühel kenal päeval, T, 2007-03-27 kell 07:11, kirjutas Andrew Dunstan: Hannu Krosing wrote: So perhaps it Alvaros proposal can be rephrased thus: Why have the name on each message? The names are already stored in listen table, just reuse numeric identifier pointing to item in that table

Re: [HACKERS] notification payloads

Ühel kenal päeval, T, 2007-03-27 kell 16:13, kirjutas Hannu Krosing: How else would we know how many copies to make for each backend or when we can release the memory in case we make one copy ? (see earlier discussion). could you post a link to archives ? Sorry, found it now. I

Re: [HACKERS] Guarenteeing complex referencial integrity through custom triggers

). Could you give an example, where postgresql fails to detect conflicting newly inserted rows ? -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com

Re: [HACKERS] notification payloads

-- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com ---(end of broadcast)--- TIP 1: if posting/reading through

Re: [HACKERS] LIKE optimization in UTF-8 and locale-C

UTF8MatchText(), which should not convert everything to wide char, but instead do byte-by-byte comparison and just be aware of UTF encoding, where it is easy to know how wide (how maby bytes/octets) each encoded character takes. -- Hannu Krosing Database Architect Skype Technologies

Re: [HACKERS] CREATE INDEX and HOT - revised design

to bite you after 2G transactions. Why not just use the isindvalid flag ? -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com ---(end

Re: [HACKERS] CREATE INDEX and HOT - revised design

-- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com ---(end of broadcast)--- TIP 9: In versions below 8.0

Re: [HACKERS] CREATE INDEX and HOT - revised design

an index on an empty table. -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com ---(end of broadcast)--- TIP 4

Re: [HACKERS] Fixing hash index build time

not match -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com NOTICE: This communication contains privileged or other confidential information. If you

Re: [HACKERS] TOASTing smaller things

)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free

Re: [HACKERS] LIKE optimization in UTF-8 and locale-C

many bytes the current (multibyte) character covers. The length is still easy to find out for UTF8 encoding, so it may be feasible to write UTF8MatchText() that is still faster than MBMatchText(). -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn

Re: [HACKERS] modifying the tbale function

in-line, without doing re-sorting on the master. With a function returning the full recordset the sorting can't be distributed very effectively, as the whole query result needs to be saved on the master node before returning. -- Hannu Krosing Database Architect Skype Technologies

Re: CREATE INDEX and HOT (was [HACKERS] Question: pg_classattributes and race conditions ?)

, if requried). Maybe using more than one TOAST table as means of vertical partitioning ? I trust that we will think of ways of extending that limit in later releases. -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me

Re: [HACKERS] [PATCHES] Bitmapscan changes

, then I can't see, how it gets the same performance effect as Index-Organized-Tables, as lot of random heap access is still needed. -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free

Re: [HACKERS] Synchronized Scan update

) into a predetermined location isn shared mem should be atomic on all platforms we support (still may cause some cache ping-pong in multiprocessor systems, but this should be much cheaper), and even an occasional error in establishing the scan head should not be catastrophic. -- Hannu Krosing

Re: [HACKERS] CLUSTER and MVCC

? In any case, the MVCC-violation needs to be documented. I'll send a doc patch to pgsql-patches shortly. -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com

Re: [HACKERS] Auto creation of Partitions

, or will it actually drop the partitions table from the whole database ? -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com ---(end of broadcast

Re: [HACKERS] Bug: Buffer cache is not scan resistant

of os cache. Do any of you know about a way to READ PAGE ONLY IF IN CACHE in *nix systems ? -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com

Re: [HACKERS] Bug: Buffer cache is not scan resistant

subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http

Re: [HACKERS] Bug: Buffer cache is not scan resistant

? regards, tom lane ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate -- Hannu Krosing Database Architect Skype

Re: [HACKERS] UPSERT

way of doing it thus: UPDATE IF NOT FOUND THEN INSERT IF DUPLICATE KEY THEN UPDATE END IF END IF At least this is how UPSERT is usually done in plpgsql -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me

Re: [HACKERS] UPSERT

Ühel kenal päeval, P, 2007-03-04 kell 07:46, kirjutas Bruno Wolff III: On Sun, Mar 04, 2007 at 14:55:47 +0200, Hannu Krosing [EMAIL PROTECTED] wrote: UPDATE IF NOT FOUND THEN INSERT IF DUPLICATE KEY THEN UPDATE END IF END IF I believe it is possible for the above

Re: [HACKERS] Revitalising VACUUM FULL for 8.3

, it may block/abort other concurrent updates, so it could be a good thing to teach the update mechanism about null updates. Still I think that this would be the chepest way to get VACUUM FULL behaviour without locking the whole table for long time -- Hannu Krosing Database

Re: [HACKERS] Revitalising VACUUM FULL for 8.3

Ühel kenal päeval, N, 2007-03-01 kell 14:32, kirjutas Hannu Krosing: If we can trust FSM, the whole process just becomes the backward scan and null updates until the null update does not move tuple to a lower page. Also, for the duration of COMPACT TABLE the updated tuple should always

Re: [HACKERS] Revitalising VACUUM FULL for 8.3

Ühel kenal päeval, N, 2007-03-01 kell 13:14, kirjutas Simon Riggs: On Thu, 2007-03-01 at 14:42 +0200, Hannu Krosing wrote: Ühel kenal päeval, N, 2007-03-01 kell 14:32, kirjutas Hannu Krosing: If we can trust FSM, the whole process just becomes the backward scan and null updates until

Re: [HACKERS] Revitalising VACUUM FULL for 8.3

and 2nd VACUUM if truncation at this cycle is absolutely needed Andreas ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate -- Hannu

Re: [HACKERS] New feature request: FlashBack Query

should involve someone who has *designed* them, not merely used them . -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com ---(end

Re: [HACKERS] wishlist items ..

to ? -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com ---(end of broadcast)--- TIP 5: don't forget to increase your free space

Re: [HACKERS] New feature request: FlashBack Query

Ühel kenal päeval, P, 2007-02-18 kell 14:27, kirjutas Joshua D. Drake: Hannu Krosing wrote: Ühel kenal päeval, L, 2007-02-17 kell 22:49, kirjutas Chad Wagner: However, they don't have vacuum, we do. Right, and I think that is more or less because Oracle doesn't need

Re: [HACKERS] HOT WIP Patch - version 2

-- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com ---(end of broadcast)--- TIP 9: In versions below 8.0

Re: [HACKERS] RFC: Temporal Extensions for PostgreSQL

Ühel kenal päeval, L, 2007-02-17 kell 11:26, kirjutas Tom Lane: Hannu Krosing [EMAIL PROTECTED] writes: How easy/hard would it be to create unique indexes on tinterval (unique here meaning non-overlapping) ? Overlapping is not an equality relation (it fails the transitive law), so I'm

Re: [HACKERS] New feature request: FlashBack Query

-- possibly solved by defaulting autovacuum to on? (seems to be the way Oracle is heading, defaulting statistics collection to on and other management features). -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me

Re: [HACKERS] RFC: Temporal Extensions for PostgreSQL

natural way, etc etc. How easy/hard would it be to create unique indexes on tinterval (unique here meaning non-overlapping) ? Is tinterval meant to be open/closed at start and end ? -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618

Re: [HACKERS] HOT WIP Patch - version 1

kind of robustness does it provide ? In other words - what failure scenario does this guard against ? I can't see the case where the xmin=xmax check can not succeed, at least not for same page tuples. -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F

Re: [HACKERS] HOT for PostgreSQL 8.3

Ühel kenal päeval, K, 2007-02-14 kell 10:41, kirjutas Tom Lane: Hannu Krosing [EMAIL PROTECTED] writes: OTOH, for same page HOT tuples, we have the command and trx ids stored twice first as cmax,xmax of the old tuple and as cmin,xmin of the updated tuple. One of these could probably be used

Re: [HACKERS] HOT for PostgreSQL 8.3

Ühel kenal päeval, T, 2007-02-13 kell 09:38, kirjutas Tom Lane: Heikki Linnakangas [EMAIL PROTECTED] writes: Hannu Krosing wrote: Are we actually doing that ? I.E are null bitmaps really allocated in 1 byte steps nowadays ? Yes. Not really; we still have to MAXALIGN at the end

Re: [HACKERS] HOT for PostgreSQL 8.3

bitmap probably doesn't matter so much because the tuples are quite wide anyway. -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com

Re: [HACKERS] HOT for PostgreSQL 8.3

do it in 2 steps - first do an update that moves the tuple to hot chain root position, and then, after the original is dead for all backends, just mark it as not hot. -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me

Re: [HACKERS] HOT for PostgreSQL 8.3

Ühel kenal päeval, P, 2007-02-11 kell 12:35, kirjutas Tom Lane: Hannu Krosing [EMAIL PROTECTED] writes: What if we would just reuse the root tuple directly instead of turning it into a stub ? This would create a cycle of ctid pointers, which changes the lookup process from 'follow ctid

Re: [HACKERS] HOT for PostgreSQL 8.3

entries, it's ok if we crash after replacing some but not all of them. The next vacuum would replace the rest of the pointers, and remove the old root tuple. -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me

Re: [HACKERS] Performance penalty of visibility info in indexes?

lots of cases where you wouldn't want the added index size. Of course. All alternative ways of storing MVCC info should be optional and user-selectable so DBA can test and select the most suitable one for each usecase. -- Hannu Krosing Database Architect Skype Technologies OÜ

Re: A more general approach (Re: [HACKERS] Data archiving/warehousing idea)

Ühel kenal päeval, N, 2007-02-01 kell 12:31, kirjutas Tom Lane: Hannu Krosing [EMAIL PROTECTED] writes: A more radical variation of the restricted-use archive table approach is storing all tuple visibility info in a separate file. At first it seems to just add overhead, but for lots (most

A more general approach (Re: [HACKERS] Data archiving/warehousing idea)

, but if it is mostly heavily compressed, it will be a lot cheaper than random access to data heap. -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com

Re: A more general approach (Re: [HACKERS] Data archiving/warehousing idea)

Ühel kenal päeval, N, 2007-02-01 kell 14:38, kirjutas Hannu Krosing: Ühel kenal päeval, N, 2007-02-01 kell 13:24, kirjutas Gavin Sherry: A different approach discussed earlier involves greatly restricting the way in which the table is used. This table could only be written

Re: [HACKERS] pgsql: Fix for plpython functions; return true/false for boolean,

---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com

Re: [HACKERS] Proposal: Snapshot cloning

no point to aquire it into read-commited transaction when the next command will revert to its own snapshot anyway. -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http

Re: [HACKERS] Recursive Queries

level variables. -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com ---(end of broadcast)--- TIP 3: Have you

Re: [HACKERS] Proposal: Snapshot cloning

. Ideas? Jan -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com ---(end of broadcast)--- TIP 1: if posting

Re: [HACKERS] (SETOF) RECORD AS complex_type

$# $$; CREATE FUNCTION hannu=# select * from bar(1); a | b | c | d ---+---+---+-- 1 | 1 | (1,1) | text 1 | 1 | (1,1) | text 1 | 1 | (1,1) | text (3 rows) -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype

Re: [HACKERS] Frequent Update Project: Design Overview ofHOTUpdates

from the index. How would this interact with HOT ? -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com ---(end of broadcast

Re: [HACKERS] [PATCHES] replication docs: split single vs.

version at: http://momjian.us/main/writings/pgsql/sgml/failover.html That somehow doesn't work for me: I lost power for a few hours. I am back online. I have updated the docs at that URL. Please check and let me know. -- Hannu Krosing Database Architect Skype

Re: [HACKERS] [PATCHES] replication docs: split single vs.

idea to give pointers to SkyTools (description: https://developer.skype.com/SkypeGarage/DbProjects/SkyTools code: http://pgfoundry.org/projects/skytools/ ) which includes a walmgr.py script which sets up and manages WAL-based standby servers. -- Hannu Krosing Database Architect

Re: [HACKERS] Frequent Update Project: Design Overview of

visible tuple in overflow. What I did not understand very well, is how do you determine, which overflow tuples are safe to remove. Do you mark/remove them when doing the copyback ? -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia

Re: [HACKERS] Frequent Update Project: Design Overview of HOT

when new chaoin head is copied iver the old one in the same-length case. http://www.postgresql.org/about/donate -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free

Re: [HACKERS] Frequent Update Project: Design Overview of HOT

Ühel kenal päeval, R, 2006-11-10 kell 09:06, kirjutas Hannu Krosing: Ühel kenal päeval, N, 2006-11-09 kell 18:28, kirjutas Tom Lane: Simon Riggs [EMAIL PROTECTED] writes: As more UPDATEs take place these tuple chains would grow, making locating the latest tuple take progressively longer

Re: [HACKERS] Replication documentation addition

for this type of clustering, there are several commercial products available that implement this approach, making PostgreSQL achieve very high performance for multi-Terabyte business intelligence databases. - Luke -- Hannu Krosing Database Architect Skype Technologies OÜ

Re: [HACKERS] Replication documentation addition

complex OLAP queries, and Pl_Proxy ( http://pgfoundry.org/projects/plproxy/ ) which does the same for OLTP loads. I think the official term for this kind of replication is Shared-Nothing Clustering. -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn

Re: [HACKERS] Is python 2.5 supported?

investigated why import_succeed() failed. Should python 2.5 work with plpython? This is about pl_python ? Forwarding to Sven to investigate -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype

Re: [HACKERS] Another idea for dealing with cmin/cmax

would be to merge FSM and TVM and then use them also for keeping data in cluster order. -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com

Re: [HACKERS] Please to technical check of upcoming release

to return recordsets. Also, named function arguments are now available in pl/python Thanks! -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com

Re: [HACKERS] pgsql: We're going to have to spell dotless i

, and utf-8 if no charset is given. -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com ---(end of broadcast

Re: [HACKERS] pgsql: We're going to have to spell dotless i

Ühel kenal päeval, P, 2006-09-24 kell 14:56, kirjutas Markus Schaber: Hi, Hannu, Hannu Krosing wrote: Are you sure it's UCS-4 ? I've always thought that XML is what is given in xml tag, and utf-8 if no charset is given. You have to distinguish between the supported charset

Re: [HACKERS] pgsql: We're going to have to spell dotless i

. -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please

Re: [HACKERS] pdfs of the conference

up in the next few days. I do apologise to everyone about the delay. I'll be sure to make an announcement when everything is done. Will there be a larger version of the group photo currently on http://www.postgresql.org's front page ? -- Hannu Krosing Database Architect Skype

Re: [HACKERS] Reducing data type space usage

-- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com NOTICE: This communication contains privileged or other confidential information. If you have received it in error, please advise

Re: [HACKERS] Reducing data type space usage

? http://www.postgresql.org/docs/faq -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com ---(end of broadcast

Re: [HACKERS] Draft release notes

to the release notes for cleanup. You should leave my name out from plpython enchancements, the actual programming was all done by Sven. * Add named parameters to plpython args[] array (Hannu Krosing, Sven Suursoho) * Return composite-types from plpython as dictionary (Hannu Krosing, Sven Suursoho

Re: [HACKERS] TODO Request

? -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com ---(end of broadcast)--- TIP 4: Have you searched our list

Re: [HACKERS] [PATCHES] Trivial patch to double vacuum speed

-- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore

Re: [HACKERS] [COMMITTERS] pgsql: Allow PL/python to return

that. There was some review, which revealed one questionable practice (not checking for NULL return) which was fixed AFAIK. Do you have anyone specific in mind who should also do the review ? Have our review standards just dropped to commit it and see what happens? -- Hannu Krosing

Re: [HACKERS] [COMMITTERS] pgsql: Allow PL/python to return

Ühel kenal päeval, L, 2006-09-02 kell 11:20, kirjutas Tom Lane: Hannu Krosing [EMAIL PROTECTED] writes: Do you have anyone specific in mind who should also do the review ? I went through the commit log for plpython.c to see who'd be a likely prospect, and was dismayed to realize

Re: [HACKERS] Prepared statements considered harmful

them on experience. I for one would not like it at all if all my queries (select * from plpgsqlfunc()) just magically become slower by 10-50% If there will be an option not to plan/optimise prepared statemants, I would certainly expect it to be off by default. -- Hannu Krosing

Re: [HACKERS] Tricky bugs in concurrent index build

-unique index first and then convert it to a unique one later, in yet another pass ? -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com

Re: [HACKERS] Tricky bugs in concurrent index build

Ühel kenal päeval, K, 2006-08-23 kell 11:05, kirjutas Hannu Krosing: Ühel kenal päeval, T, 2006-08-22 kell 16:48, kirjutas Tom Lane: Joshua D. Drake [EMAIL PROTECTED] writes: It's fairly clear that we could support concurrent builds of nonunique indexes, but is that enough of a use-case

Re: [HACKERS] Replication

like myrinet. -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com ---(end of broadcast)--- TIP 2: Don't 'kill

Re: [HACKERS] Replication

replication needs to be based on your business rules which will vary widely. -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com

Re: [HACKERS] Question about (lazy) vacuum

by vacuum and short ones which write data to system tables and are not ignored. That way we have one less obstacle for keeping high-update tables in shape. -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me

Re: [HACKERS] Replication

Ühel kenal päeval, K, 2006-08-23 kell 13:09, kirjutas Markus Schiltknecht: Hannu Krosing wrote: But any sync _replication_ system will have severe impact on performance. My guess is that for a full sync replication, going from 1 server to 2 will actually lower performance andsome small

Re: [HACKERS] Question about (lazy) vacuum

Ühel kenal päeval, K, 2006-08-23 kell 08:11, kirjutas Greg Stark: Hannu Krosing [EMAIL PROTECTED] writes: BTW, I think that CONCURRENT CREATE INDEX should be modified to use long transactions which actually build the index and are ignored by vacuum and short ones which write data to system

Re: [HACKERS] Tricky bugs in concurrent index build

duplicate value are checked, to release locks on those tuples. -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com ---(end of broadcast

Re: [HACKERS] Replication

Ühel kenal päeval, K, 2006-08-23 kell 13:36, kirjutas Markus Schiltknecht: Hannu Krosing wrote: But if you have very few writes, then there seems no reason to do sync anyway. I think there is one: high-availability. A standby-server which can continue if your primary fails. Of course

[HACKERS] Removing the performance gap caused by CHECKPOINT

On postgresql anniversary summit there was a presentation byt SRA people about using background writer to do CHECKPOINTs which seemed very effective for removing the performance gap caused by CHECKPOINT. Has any of it been submitted for 8.2 ? -- Hannu Krosing Database Architect

Re: [HACKERS] An Idea for planner hints

column combinations. I understood that the proposal was to collect only the stats where needed (determined by user/dba) and use some rule-of-thumb values if no collected stats were available. -- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn

<    3   4   5   6   7   8   9   10   11   12   >