RE: [HACKERS] low priority postmaster threads?
Tom Lane Wrote: The trouble here is that CPU nice doesn't (on most platforms) change the behavior of the I/O scheduler, so this would only be of use to the extent that your queries are CPU bound and not I/O bound. Assuming there is a major processor hit, and the backend has a UW-SCSI RAID box with enough I/O capability... What happens when the low-priority process holds some lock or other, and then a higher-priority process comes along and wants the lock? If the query was a select only, would the locking problem still apply? (The long queries in this case are in the form of 'select * from [all tables joined together] where x') I will make a couple of changes and test it to see if there are any performance gains in particular cases. The other option is to add another processor :) Chris
Re: [HACKERS] RE: Re: [ADMIN] v7.1b4 bad performance
Lincoln Yeoh wrote: Just another data point. I downloaded a snapshot yesterday - Changelogs dated Feb 20 17:02 It's significantly slower than "7.0.3 with fsync off" for one of my webapps. 7.0.3 with fsync off gets me about 55 hits per sec max (however it's interesting that the speed keeps dropping with continued tests). ( PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66) For 7.1b4 snapshot I get about 23 hits per second (drops gradually too). I'm using Pg::DBD compiled using the 7.1 libraries for both tests. (PostgreSQL 7.1beta4 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66) For a simple "select only" webapp I'm getting 112 hits per sec for 7.0.3. and 109 hits a sec for the 7.1 beta4 snapshot. These results remain quite stable over many repeated tests. The first webapp does a rollback, begin, select, update, commit, begin, a bunch of selects in sequence and rollback. It may be that WAL has changed the rollback time-characteristics to worse than pre-wal ? If that is the case tha routeinely rollbacking transactions is no longer a good programming practice. It may have used to be as I think that before wal both rollback and commit had more or less the same cost. So my guess is that the 7.1 updates (with default fsync) are significantly slower than 7.0.3 fsync=off now. the consensus seems to be that they are only "a little" slower. But it's interesting that the updates slow things down significantly. Going from 50 to 30 hits per second after a few thousand hits for 7.0.3, and 23 to 17 after about a thousand hits for 7.1beta4. For postgresql 7.0.3 to speed things back up from 30 to 60 hits per sec I had to do: - Hannu
Re: [HACKERS] Re: [ADMIN] v7.1b4 bad performance
I wrote: I tried with -B 1024 10 times for commit_delay=0 and 1 respectively. The average result of 'pgbench -c 10 -t 100' is as follows. [commit_delay=0] 26.462817(including connections establishing) 26.788047(excluding connections establishing) [commit_delay=1] 27.630405(including connections establishing) 28.042666(excluding connections establishing) I got another clear result by simplifying pgbench. [commit_delay = 0] 1)tps = 52.682295(including connections establishing) tps = 53.574140(excluding connections establishing) 2)tps = 54.580892(including connections establishing) tps = 55.672988(excluding connections establishing) 3)tps = 60.409452(including connections establishing) tps = 61.740995(excluding connections establishing) 4)tps = 60.787502(including connections establishing) tps = 62.131317(excluding connections establishing) 5)tps = 60.968409(including connections establishing) tps = 62.328142(excluding connections establishing) 6)tps = 62.396566(including connections establishing) tps = 63.614357(excluding connections establishing) 7)tps = 52.720152(including connections establishing) tps = 54.811739(excluding connections establishing) 8)tps = 53.417274(including connections establishing) tps = 54.454355(excluding connections establishing) 9)tps = 54.862412(including connections establishing) tps = 55.953512(excluding connections establishing) 10)tps = 60.616255(including connections establishing) tps = 63.423590(excluding connections establishing) [commit_delay = 1] 1)tps = 68.458715(including connections establishing) tps = 71.147012(excluding connections establishing) 2)tps = 71.059064(including connections establishing) tps = 72.685829(excluding connections establishing) 3)tps = 67.625556(including connections establishing) tps = 69.288699(excluding connections establishing) 4)tps = 84.749505(including connections establishing) tps = 87.430563(excluding connections establishing) 5)tps = 83.001418(including connections establishing) tps = 85.525377(excluding connections establishing) 6)tps = 66.235768(including connections establishing) tps = 67.830999(excluding connections establishing) 7)tps = 80.993308(including connections establishing) tps = 87.333491(excluding connections establishing) 8)tps = 69.844893(including connections establishing) tps = 71.640972(excluding connections establishing) 9)tps = 71.135311(including connections establishing) tps = 72.979021(excluding connections establishing) 10)tps = 68.091439(including connections establishing) tps = 69.539728(excluding connections establishing) The patch to let pgbench execute 1 query/trans is the following. Index: pgbench.c === RCS file: /home/cvs/pgcurrent/contrib/pgbench/pgbench.c,v retrieving revision 1.1 diff -c -r1.1 pgbench.c *** pgbench.c 2001/02/20 07:55:21 1.1 --- pgbench.c 2001/02/22 10:03:52 *** *** 217,222 --- 217,224 st-state = 0; } + if (st-state 1) + st-state=6; switch (st-state) { case 0: /* about to start */ Regards, Hiroshi Inoue
RE: [HACKERS] beta5 ...
On Thu, 22 Feb 2001, Christopher Kings-Lynne wrote: What about adding a field where they paste the output of 'uname -a' on their system...? Got this and Justin's changes along with compiler version. Anyone think of anything else? Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
[HACKERS] GPL, readline, and static/dynamic linking
Here is an article about GPL and GPL version 3.0. http://icd.pennnet.com/Articles/Article_Display.cfm?Section=ArticlesSubSection=DisplayARTICLE_ID=92350VERSION_NUM=1 The interesting thing is that Stallman says: "Our position is that it makes no difference whether programs are linked statically or dynamically," explains Stallman. "Either one makes a combined program. This would seem to imply that our dynamic linking of libreadline in PostgreSQL backend binaries makes the distribution of backend binaries fall under the GPL. (Of course, we can use *BSD libedit now.) Let me add I don't agree with this, and find the whole GPL heavy-handedness very distasteful. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026
RE: [HACKERS] beta5 ...
Vince Vielhaber writes: On Thu, 22 Feb 2001, Christopher Kings-Lynne wrote: What about adding a field where they paste the output of 'uname -a' on their system...? Got this and Justin's changes along with compiler version. Anyone think of anything else? Architecture. IRIX, Solaris and AIX allow applications and libraries to be built 32 or 64 bit. You may also like to add a field for configure options used. Or is this just for results OOTB? -- Pete Forman -./\.- Disclaimer: This post is originated WesternGeco -./\.- by myself and does not represent [EMAIL PROTECTED] -./\.- opinion of Schlumberger, Baker http://www.crosswinds.net/~petef -./\.- Hughes or their divisions.
Re: [HACKERS] beta5 ...
Vince Vielhaber writes: http://hub.org/~vev/regress.php What other info is needed to distinguish these systems? The operating systems should be ordered by some key other than maybe author's preference. ;-) Linux needs to be split into one for each distribution. 'Sun' should probably be SunOS. Also of interest: - config.guess output - Linker version - GNU make version - configure command line (`pg_config --configure`) Bison version is probably not interesting, since anything but 1.28 is not to be considered serious. 'Platform' could be better named 'CPU type'. 'CPU speed' and 'Total RAM' are probably not interesting for anything but statistics. 'libc' version is probably not interesting for anything but Linux? If so, it is already implied if you name the distributor. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Re: [HACKERS] beta5 ...
Got this and Justin's changes along with compiler version. Anyone think of anything else? Hmm. Any suggestions on how we collate the test results for our release docs? And how we solicit tests for remaining platforms? In previous releases (and until now), I have kept track of results posted on the -hackers mailing list, and then when the beta cycle winds down would send out a list containing those platforms which have not yet been tested. It was easy for me to do, and it gave visibility on the developers' list for the current status of testing. Should the procedure now change? And if so, have we just signed me up for more work rummaging around a web page to transcribe results? :/ Could we perhaps have a reference on that page to the current developer's doc page of "supported platforms"? That would help tie the current state of the docs to the current state of the web site report form, and it would let people know that they might also post their results to the -hackers list to make sure that their results are known to others. If we are storing this stuff in a database, then perhaps it would be easy to dump those results in a form which maps into the docs? philosophy style=randomthought mode=aside I *know* that having web pages for data entry, etc etc are good things. But at some point, the fun of working on PG is (at least for me) interacting with *people*, not web sites, and I'd like to avoid building in procedures which inadvertently discourage that interaction. /philosophy Suggestions? - Thomas
Re: [HACKERS] beta5 ...
On Thu, 22 Feb 2001, Peter Eisentraut wrote: Vince Vielhaber writes: http://hub.org/~vev/regress.php What other info is needed to distinguish these systems? The operating systems should be ordered by some key other than maybe author's preference. ;-) Actually it's more random than by preference. FreeBSD came first 'cuze I run it and I always list it first (and alphabetically it comes before Linux). I then kept the bsds together, but those were actually added last. Some of the others came from looking at the directory where the FAQs reside and going in that order. Linux needs to be split into one for each distribution. I need a list of them since the only ones I can think of are redhat, suse and slackware (does slackware even still exist?). 'Sun' should probably be SunOS. Ok. Also of interest: - config.guess output comes later. This is mainly for machine identification. But it is noted since I didn't think of it. - Linker version - GNU make version - configure command line (`pg_config --configure`) Comes later. Bison version is probably not interesting, since anything but 1.28 is not to be considered serious. 'Platform' could be better named 'CPU type'. 'CPU speed' and 'Total RAM' are probably not interesting for anything but statistics. Changed platform. 'libc' version is probably not interesting for anything but Linux? If so, it is already implied if you name the distributor. And if someone upgrades libc? I add that 'cuze when a friend of mine was using redhat for his isp (quite a while ago) someone upgraded his libc for him - what a mess that made! Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [HACKERS] GPL, readline, and static/dynamic linking
Bruce Momjian [EMAIL PROTECTED] writes: Here is an article about GPL and GPL version 3.0. http://icd.pennnet.com/Articles/Article_Display.cfm?Section=ArticlesSubSection=DisplayARTICLE_ID=92350VERSION_NUM=1 The interesting thing is that Stallman says: "Our position is that it makes no difference whether programs are linked statically or dynamically," explains Stallman. "Either one makes a combined program. This would seem to imply that our dynamic linking of libreadline in PostgreSQL backend binaries makes the distribution of backend binaries fall under the GPL. This was discussed extensively earlier. Linking dynamically or statically doesn't make a difference in the case of a library, but as long as readline is an optional feature for the user it's not a problem. -- Trond Eivind Glomsrd Red Hat, Inc.
RE: [HACKERS] beta5 ...
On Thu, 22 Feb 2001, Pete Forman wrote: Vince Vielhaber writes: On Thu, 22 Feb 2001, Christopher Kings-Lynne wrote: What about adding a field where they paste the output of 'uname -a' on their system...? Got this and Justin's changes along with compiler version. Anyone think of anything else? Architecture. IRIX, Solaris and AIX allow applications and libraries to be built 32 or 64 bit. Added. You may also like to add a field for configure options used. Or is this just for results OOTB? That comes later. This part is just for identifying the system itself. Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
Re: [HACKERS] beta5 ...
On Thu, 22 Feb 2001, Thomas Lockhart wrote: Got this and Justin's changes along with compiler version. Anyone think of anything else? Hmm. Any suggestions on how we collate the test results for our release docs? And how we solicit tests for remaining platforms? In previous releases (and until now), I have kept track of results posted on the -hackers mailing list, and then when the beta cycle winds down would send out a list containing those platforms which have not yet been tested. Can you provide me with a list of platforms it should be tested on? It was easy for me to do, and it gave visibility on the developers' list for the current status of testing. Should the procedure now change? And if so, have we just signed me up for more work rummaging around a web page to transcribe results? :/ No, I wouldn't do that to you. You tell me how you want the results to look and I'll give you copy-n-paste. All of this info will be stored in a table so the output is however it's wanted. Could we perhaps have a reference on that page to the current developer's doc page of "supported platforms"? That would help tie the current state of the docs to the current state of the web site report form, and it would let people know that they might also post their results to the -hackers list to make sure that their results are known to others. If we are storing this stuff in a database, then perhaps it would be easy to dump those results in a form which maps into the docs? No problem. philosophy style=randomthought mode=aside I *know* that having web pages for data entry, etc etc are good things. But at some point, the fun of working on PG is (at least for me) interacting with *people*, not web sites, and I'd like to avoid building in procedures which inadvertently discourage that interaction. /philosophy Suggestions? If anything this will make it easier for you and give you more time to interact and less time to have to dig for results which may not be as complete as you'd like. Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
RE: [HACKERS] beta5 ...
I think UP or SMP should be an option to check, perhaps just a box for the number of processors. Also something to capture the compile flags. I have a dual Ppro, and it compiles fine unless I use the -j3 or -j4 commands, then I get an error. Matt -Original Message- From: Vince Vielhaber [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 10:57 AM To: Pete Forman Cc: [EMAIL PROTECTED] Subject: RE: [HACKERS] beta5 ... On Thu, 22 Feb 2001, Pete Forman wrote: Vince Vielhaber writes: On Thu, 22 Feb 2001, Christopher Kings-Lynne wrote: What about adding a field where they paste the output of 'uname -a' on their system...? Got this and Justin's changes along with compiler version. Anyone think of anything else? Architecture. IRIX, Solaris and AIX allow applications and libraries to be built 32 or 64 bit. Added. You may also like to add a field for configure options used. Or is this just for results OOTB? That comes later. This part is just for identifying the system itself. Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
FW: [HACKERS] beta5 ...
I believe it was straight from CVS, perhaps it was the beta4 tarball. Don't know if that counts as a distribution tarball or not. I will test the 7.0.3 release, and double check what the error I'm getting if you would like. -Original Message- From: Peter Eisentraut [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 12:54 PM To: Matthew Cc: 'Vince Vielhaber'; Pete Forman; [EMAIL PROTECTED] Subject: RE: [HACKERS] beta5 ... Matthew writes: I think UP or SMP should be an option to check, perhaps just a box for the number of processors. Also something to capture the compile flags. I have a dual Ppro, and it compiles fine unless I use the -j3 or -j4 commands, then I get an error. Which error? Parallel make doesn't work when you build from a CVS tree, but it should work with a distribution tarball. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
[HACKERS] Re: GPL, readline, and static/dynamic linking
This was discussed extensively earlier. Linking dynamically or statically doesn't make a difference in the case of a library, but as long as readline is an optional feature for the user it's not a problem. I agree with Trond on this. It's like the problem that PHP had with bc until it got LGPLed. All they did was say you could compile PHP with it, but you had to downloaded by ourself. Yes, we don't distribute libreadline. We just check in 'configure' for it. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026
Re: [HACKERS] GPL, readline, and static/dynamic linking
On Thu, Feb 22, 2001 at 10:50:17AM -0500, Bruce Momjian wrote: Let me add I don't agree with this, and find the whole GPL heavy-handedness very distasteful. Please, not this again. Is there a piss-and-moan-about-the-GPL schedule posted somewhere? Either PG is in compliance, or it's not. Only libreadline's copyright holder has the right to complain if it's not. There is no need to speculate; if we care about compliance, we need only ask the owner. If the owner says we're violating his license, then we can comply, or negotiate, or stop using the code. The GPL is no different from any other license, that way. Complaining about the terms on something you got for nothing has to be the biggest waste of time and attention I've seen on this list. Nathan Myers [EMAIL PROTECTED]
[HACKERS] Re: [ADMIN] v7.1b4 bad performance
Lincoln Yeoh wrote: Oops. I rechecked the start up script, and the 7.0.3 doesn't have fsync off or whatever. Dunno why I thought it was on (heh maybe because it was a lot faster than 6.5.3!). Hmm, this means 7.0.3 is quite fast... Your app seems to have many rollbacks. Yes rollback of 7.0 is a lot faster than 6.5 even when fsync on. Regards, Hiroshi Inoue
Re: [HACKERS] beta5 ...
Hi Vince, Here's the next thing... how do you want to distinguish between Solaris SPARC, Solaris INTEL (and maybe even Solaris MAC even though it isn't sold any longer)? Each of these has a 32 and 64 bit mode also. I thought that might be what "Platform" could be used for, but "Architecture" sounds right. Regards and best wishes, Justin Clift Database Administrator Vince Vielhaber wrote: snip Bison version is probably not interesting, since anything but 1.28 is not to be considered serious. 'Platform' could be better named 'CPU type'. 'CPU speed' and 'Total RAM' are probably not interesting for anything but statistics. Changed platform. 'libc' version is probably not interesting for anything but Linux? If so, it is already implied if you name the distributor. And if someone upgrades libc? I add that 'cuze when a friend of mine was using redhat for his isp (quite a while ago) someone upgraded his libc for him - what a mess that made! Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com ==
[HACKERS] Re: beta5 ...
Can you provide me with a list of platforms it should be tested on? The current list is at http://www.postgresql.org/devel-corner/docs/admin/supported-platforms.html No, I wouldn't do that to you. You tell me how you want the results to look and I'll give you copy-n-paste. All of this info will be stored in a table so the output is however it's wanted. OK, if we entered in the current list of supported platforms, or even if not, that could form the basis for the "solicitation email" to get the rest of the platforms tested. Look at what I collate in the docs, but if you give me more that won't be a problem. btw, for docs I'm not sure how to include much more information, since it has to fit on a page (in tabular form, presumably). Suggestions? Could we perhaps have a reference on that page to the current developer's doc page of "supported platforms"? blah blah blah No problem. Ok, the URL would be the same as above, for *development*. Not sure how we will do the same info on the "released side" of the web site? If anything this will make it easier for you and give you more time to interact and less time to have to dig for results which may not be as complete as you'd like. Yup, you are right. Thanks. Hmm, would generating an email to the -hackers list when something gets updated be useful? istm it would not end up being spam, but what do y'all think? - Thomas
Re: [GENERAL] Chinese patch for Pgaccess
Hi all: The attachement is the Chinese (GB) patch for PgAccess, don't know if it's correct to post here. It's simple to do the translation, And I've test in 7.0.2 current CVS, seems pretty good. If anyone want this little thing, I'll very happy. use it is very simple, just gunzip it and copy to $PGDIR/share/pgaccess/lib/languages/ for current CVS version, and $PGDIR/pgaccess/lib/languages/ for 7.0* BTW: I havn't got the tools to translate it to BIG5 encoding, is there anybody to to it? OK, I have added this to the other pgaccess language files. I think the file name (src/bin/pgaccess/lib/languages/chinese) is not appropriate. There are several encodings for Chinese including GB(EUC-CN), Big5, EUC-TW. At least we should be able to distinguish them. What about "chinese(GB)" or whatever? -- Tatsuo Ishii
[HACKERS] Re: [INTERFACES] Re: [GENERAL] Chinese patch for Pgaccess
Hi all: The attachement is the Chinese (GB) patch for PgAccess, don't know if it's correct to post here. It's simple to do the translation, And I've test in 7.0.2 current CVS, seems pretty good. If anyone want this little thing, I'll very happy. use it is very simple, just gunzip it and copy to $PGDIR/share/pgaccess/lib/languages/ for current CVS version, and $PGDIR/pgaccess/lib/languages/ for 7.0* BTW: I havn't got the tools to translate it to BIG5 encoding, is there anybody to to it? OK, I have added this to the other pgaccess language files. I think the file name (src/bin/pgaccess/lib/languages/chinese) is not appropriate. There are several encodings for Chinese including GB(EUC-CN), Big5, EUC-TW. At least we should be able to distinguish them. What about "chinese(GB)" or whatever? Renamed to chinese-gb. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026
[HACKERS] Lock structures
Can someone explain why LockMethodCtl is in shared memory while LockMethodTable is in postmaster memory context? I realize LockMethodCtl has a spinlock, so it has to be in shared memory, but couldn't it all be put in shared memory? Also, the code: LockShmemSize(int maxBackends) { int size = 0; size += MAXALIGN(sizeof(PROC_HDR)); /* ProcGlobal */ size += MAXALIGN(maxBackends * sizeof(PROC)); /* each MyProc*/ size += MAXALIGN(maxBackends * sizeof(LOCKMETHODCTL)); /* each * lockMethodTable-ctl */ Is there one LOCKMETHODCTL for every backend? I thought there was only one of them. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026
Re: [HACKERS] RE: Re: [ADMIN] v7.1b4 bad performance
Vadim Mikheev wrote: It may be that WAL has changed the rollback time-characteristics to worse than pre-wal ? Nothing changed ... yet. And in future rollbacks of read-only transactions will be as fast as now, anyway. What about rollbacks of a bunch uf inserts/updates/deletes? I remember a scenario where an empty table was used by several backends for gathering report data, and when the report is done they will rollback to keep the table empty. Should this kind of usage be replaced in the future by having backend id as a key and then doing delete by that key in the end ? -- Hannu
[HACKERS] Chinese patch for Pgaccess
Hi all: The attachement is the Chinese (GB) patch for PgAccess, don't know if it's correct to post here. It's simple to do the translation, And I've test in 7.0.2 current CVS, seems pretty good. If anyone want this little thing, I'll very happy. use it is very simple, just gunzip it and copy to $PGDIR/share/pgaccess/lib/languages/ for current CVS version, and $PGDIR/pgaccess/lib/languages/ for 7.0* BTW: I havn't got the tools to translate it to BIG5 encoding, is there anybody to to it? Regards Laser chinese_gb.gz
Re: [HACKERS] Re: [INTERFACES] Re: [GENERAL] Chinese patch for Pgaccess
appropriate. There are several encodings for Chinese including GB(EUC-CN), Big5, EUC-TW. At least we should be able to distinguish them. What about "chinese(GB)" or whatever? Renamed to chinese-gb. I think chinese-gb is ok, thanks! I ended up using chinese_gb. The underscore was more consistent. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026
Re: [HACKERS] Re: [INTERFACES] Re: [GENERAL] Chinese patch for Pgaccess
appropriate. There are several encodings for Chinese including GB(EUC-CN), Big5, EUC-TW. At least we should be able to distinguish them. What about "chinese(GB)" or whatever? Renamed to chinese-gb. I think chinese-gb is ok, thanks! Regards Laser
Re: [GENERAL] Chinese patch for Pgaccess
Hi all: The attachement is the Chinese (GB) patch for PgAccess, don't know if it's correct to post here. It's simple to do the translation, And I've test in 7.0.2 current CVS, seems pretty good. If anyone want this little thing, I'll very happy. use it is very simple, just gunzip it and copy to $PGDIR/share/pgaccess/lib/languages/ for current CVS version, and $PGDIR/pgaccess/lib/languages/ for 7.0* BTW: I havn't got the tools to translate it to BIG5 encoding, is there anybody to to it? OK, I have added this to the other pgaccess language files. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026