Re: [HACKERS] [PATCHES] Forcing current WAL file to be archived

Albe Laurenz wrote: Simon Riggs wrote: Patch included to implement xlog switching, using an xlog record "processing instruction" and forcibly moving xlog pointers. 1. Happens automatically on pg_stop_backup() Oh - so it will not be possible to do an online backup _without_ forcing a WAL swi

Re: [HACKERS] Worthwhile optimisation of position()?

ay it can use an index. I think the '= 0' bit is what Chris was suggesting could be the basis for an optimisation. Tim -- --- Tim Allen [EMAIL PROTECTED] Proximity Pty Ltd http://www.proximity.com.au/ ---(end of

Re: [HACKERS] [ADMIN] Major Problem, need help! Can't run our website!

" full of log files? Eg pg_wal - something where the half-educated will have no idea what it is, and therefore not think they know what they can do with it. Tim -- ------- Tim Allen [EMAIL PROTECTED] Proximity Pty Ltd http://www.proximity.com.a

Re: [HACKERS] 4D Geometry

hings harder. Tim -- ------- Tim Allen [EMAIL PROTECTED] Proximity Pty Ltd http://www.proximity.com.au/ ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] Autovacuum in the backend

and to be listened to. But for what it's worth, Alvaro, please keep going, don't be dissuaded. Tim -- --- Tim Allen [EMAIL PROTECTED] Proximity Pty Ltd http://www.proximity.com.au/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] LGPL

come obliged to give that someone else the rights that the GPL requires. So linking to GPL (or LGPL) code is not acceptable for the PostgreSQL project itself, but might be acceptable for you personally, depending on what you're doing. Tim -- ------- Tim A

Re: [HACKERS] Views, views, views! (long)

keep meaning to write a view for it myself, but haven't ever gotten a round tuit. Tim -- ------- Tim Allen [EMAIL PROTECTED] Proximity Pty Ltd http://www.proximity.com.au/ http://www4.tpg.com.au/users/rita_tim/

Re: [HACKERS] Patent issues and 8.1

he size of my contribution to postgresql to date. Tim -- --- Tim Allen [EMAIL PROTECTED] Proximity Pty Ltd http://www.proximity.com.au/ http://www4.tpg.com.au/users/rita_tim/ ---(end of broadcast)--- TIP 5:

Re: [HACKERS] bug fix request

pastes and couldn't reproduce it :/ That last one is probably due to tabs in the pasted text. Happens to me all the time... Chris Tim -- ------- Tim Allen [EMAIL PROTECTED] Proximity Pty Ltd http://www.proximity.com.au/ http://www4.tpg.com.au

Re: [HACKERS] Status report: regex replacement

th at least both UTF-8 and UTF-16. Strong agreement from me, for whatever value you wish to place on my opinion. UTF-8 is a preferable name to UNICODE. The case for distinguishing 7-bit from 8-bit latin1 seems much weaker. Tim -- --- Tim Allen

Re: [HACKERS] Proposal: CREATE CONVERSION

time I checked, PostgreSQL only supports the UCS2 subset of Unicode, ie 16 bits. From the Unicode propaganda I've read, it seems that one of the main goals of the expansion of the range beyond 16 bits was to answer the complaints of Japanese users. Tim -- ----

[HACKERS] MS interview

yone can match their "investment" of "800 professionals" to work on SQL Server. Now I'm sure he didn't mean it to sound this way, but what I conclude from that is that you fellows are all an order of magnitude or two more productive than anyone at Microsoft :-). Tim -- -

Re: [HACKERS] Vague idea for allowing per-column locale

guage) sort, so no need to take me too seriously :). > Tatsuo Ishii Tim -- ------- Tim Allen [EMAIL PROTECTED] Proximity Pty Ltd http://www.proximity.com.au/ http://www4.tpg.com.au/users/rita_tim/ ---(end of broadca

[HACKERS] analyze strangeness

Linux 6.2, x86. Tim -- ------- Tim Allen [EMAIL PROTECTED] Proximity Pty Ltd http://www.proximity.com.au/ http://www4.tpg.com.au/users/rita_tim/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe c

Re: [HACKERS] Plans for solving the VACUUM problem

cs, then that's much better than the current situation. Presumably one could also retain the option of doing an explicit analyze occasionally, if you have processor cycles to burn and are really keen to get the stats correct in a hurry. Tim -- ----------

[HACKERS] Database corruption in 7.0.3

at least one customer site, so there is some possibility it's related to dodgy hardware. The customer box with the problem is a multi-processor box, all the other boxes we've tested on are single-processor. TIA for any help, Tim -- --- Tim

Re: [HACKERS] WAL & SHM principles

ng of WAL write/flush and data page writes. > > > > Bummer. > > > BTW, what means "bummer" ? It's a Postgres-specific extension to the SQL standard. It means "I am disappointed". As far as I can tell, you _may_ use it as a column or table name. :-) Tim

RE: [HACKERS] Why vacuum?

ay, but I'm not holding that up as a benchmark either ;-). > Chris Tim -- --- Tim Allen [EMAIL PROTECTED] Proximity Pty Ltd http://www.proximity.com.au/ http://www4.tpg.com.au/users/rita_tim/

[HACKERS] C++ client libs

some other obscure place. A public discussion will get you useful input from a much wider range of people. And it would make a welcome change from the usual "Help! Help! MS Access has made all my fields read-only!" and "Why doesn't the JDBC driver implement this?"