Re: [HACKERS] Including Snapshot Info with Indexes
Hi, I think i have a initial Implementation. It has some bugs and i am working on fixing it. But to show the advantages, I want to show the number of Logical I/Os on the screen. In order to show that, i tried enabling the log_statement option in PostgreSQL.conf. But it shows only the physical reads. What i wanted was a Logical reads count( No. of ReadBuffer calls, which is stored in ReadBufferCount variable). So i have added this stats to the bufmgr.c(function is BufferUsage, i suppose) to show Logical Reads and Physical Reads. Is this a acceptable change? I thought logical read count would be helpful, even for SQL tuning. Since if someone wants to tune the SQL on a test system, things might get cached and he wouldn't know how much I/O his SQL is potentially capable of. May be we can add a statistic to show how many of those ReadBuffers are pinned Buffers. Expecting your comments. Thanks, Gokul. On 10/14/07, Gokulakannan Somasundaram <[EMAIL PROTECTED]> wrote: > > > > On 10/14/07, Trevor Talbot <[EMAIL PROTECTED]> wrote: > > > > On 10/14/07, Gokulakannan Somasundaram <[EMAIL PROTECTED]> wrote: > > > > > http://www.databasecolumn.com/2007/09/one-size-fits-all.html > > > > > > > The Vertica database(Monet is a open source version with the same > > > > > principle) makes use of the very same principle. Use more disk > > space, > > > > > since they are less costly and optimize the data warehousing. > > > > > What i meant there was, it has duplicated storage of certain columns > > of the > > > table. A table with more than one projection always needs more space, > > than a > > > table with just one projection. By doing this they are reducing the > > number > > > of disk operations. If they are duplicating columns of data to avoid > > reading > > > un-necessary information, we are duplicating the snapshot information > > to > > > avoid going to the table. > > > > Was this about Vertica or MonetDB? I saw that article a while ago, > > and I didn't see anything that suggested Vertica duplicated data, just > > that it organized it differently on disk. What are you seeing as > > being duplicated? > > > Hi Trevor, > This is a good paper to read about the basics of > Column-oriented databases. > http://db.lcs.mit.edu/projects/cstore/vldb.pdf > If you goto the Section 2 - Data Model. He has shown the data model, with > a sample EMP table. > > The example shows that EMP table contains four columns - Name, Age, Dept, > Salary > From this table, projections are being formed - (In the paper, they have > shown the creation of four projections for Example 1) > EMP1 (name, age) > EMP2 (dept, age, DEPT.floor) > EMP3 (name, salary) > DEPT1(dname, floor) > > As you can see, the same column information gets duplicated in different > projections. > The advantage is that if a query is around name and age, it need not skim > around other details. But the storage requirements go high, since there is > redundancy. As you may know, if you increase data redundancy, it will help > selects at the cost of inserts, updates and deletes. > > This is what i was trying to say. > > Thanks, > Gokul. > > >
[HACKERS] 8.3 GSS Issues
I know I haven't been very active for a while here, but I just got to testing the October 3 version a bit prior to getting back to the Java GSS client stuff I promised. There seem to be some funny things there. The only serious issue is that the server doesn't require the realm name to match. I haven't looked at how that broke yet, but I know I was careful of that point in my original patches because it's always been wrong in the Kerberos 5 auth method. If I set up a server I might conceivably get connections from: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] to how NASA set up AD> Now the only two of those that *might* be the same person are the first two, and that's only if the Stanford person has a grant to work on a JPL project and got put in our infrastructure as an affiliate, *and* the username wasn't already taken. It appears that you can just put a complete (realm-included) name into postgres, so that's obviously the way to support gssapi connections from non-default realms. In short this is a security hole. IMO it should be fixed prior to release. - I notice there are hba options for gss and sspi both. Why? Is there some windows-only functionality it enables? Shouldn't we be using Microsoft's advertised GSSAPI/SSPI compatibility? If you build on Windows then I'm sure you want to link the SSPI libraries rather than require installation of a separate package, but that shouldn't change the functionality or the wire protocol AFAIK. In other words I would expect this to be a build-time option. - At the risk of diluting my message: I still think it's a mistake to call it gss instead of something like gss-noprot. I believe this will cause misunderstandings in the future when we get the security layer of gssapi implemented. - There's no way to specify the gssapi library to use. I have three on my main development Sun: MIT, Sun, and Heimdal. I might have more than one version of one of those three at some times. Of course there's no way to specify which kerberos 5 library or openssl library you want either, so consider this a feature request for future development. The opinions expressed in this message are mine, not those of Caltech, JPL, NASA, or the US Government. [EMAIL PROTECTED], or [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] dblink un-named connection doesn't get re-used
Decibel! wrote: On Oct 18, 2007, at 11:17 PM, Joe Conway wrote: Seriously though, I can change it for 8.3, but is it really worth back-patching? I think it'd be worth changing for 8.3. While C forces you to worry about memory, SQL does not, so I bet this is a surprise to most folks. I don't think anyone has ever noticed -- certainly not enough to complain in the past 5 years. This behavior has been the same since day one. I don't mind changing it, but I don't see it as a big deal. It might be worth backpatching the docs, because they're wrong. How so? Please provide better wording if you don't like what it currently says. Simply saying it is wrong is unhelpful. Joe ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] dblink un-named connection doesn't get re-used
On Oct 18, 2007, at 11:17 PM, Joe Conway wrote:
Decibel! wrote:
Is it intentional that dblink's unnamed connections don't get re-
used?
yes
stats=# select dblink_connect('dbname=stats');
dblink_connect
OK
(1 row)
stats=# select dblink_connect('dbname=postgres');
dblink_connect
OK
(1 row)
AFAIK there's no way I could possibly use or refer to the
connection to stats at this point; so why doesn't dblink close it
when I issue the second connect?
Why doesn't C free allocated memory automatically if you reassign a
pointer?
No one has ever complained before, so I can't imagine that the
resource leak is much of an issue in real world cases. But if you
don't like the behavior, patches are gratefully accepted ;-).
Seriously though, I can change it for 8.3, but is it really worth
back-patching?
I think it'd be worth changing for 8.3. While C forces you to worry
about memory, SQL does not, so I bet this is a surprise to most folks.
It might be worth backpatching the docs, because they're wrong.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
Re: [HACKERS] ts_rewrite aggregate API seems mighty ugly
BTW, I noticed while poking at this that the 2-arg form of ts_rewrite() is labeled proretset = true in pg_proc.h. This must be a typo, since a moment's glance at the code shows it cannot return a set. Good thing we didn't ship beta2 yet ... regards, tom lane ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [HACKERS] Debugger
Excuse me, My previous email, I had a problem formatting of my text. So it is not understandable. Correcting: Pinged the following steps in the console: 1. Pinged the command postgres to start. 2. Joined in psql. 3. Typed the following command to get the id of the process: "SELECT pg_backend_pid();" 4. Tried to attach the id of the process to the debugger and gave the error: "Unable to open socket file: target process not responding or HotSpot VM not loaded" 2007/10/19, Pedro Belmino <[EMAIL PROTECTED]>: > > I am using linux. > 1. Inicializei the postgres the console by running. / Postgres. > 2. Joined in psql through console and simulated. / Psql > 3. Pg_backend_pid swirled SELECT () to get the id of the process; > 4. In ide tried to use that process to attach the debugger but gives the > following error message: > Unable to open file socket: target process not responding HotSpot VM or > not loaded > > Thank, > 2007/10/19, Gregory Stark <[EMAIL PROTECTED]>: > > > > > > "Pedro Belmino" <[EMAIL PROTECTED]> writes: > > > > > Hellow, > > > I continue to have problems using the debugger, can not achieve any > > > breakpoint that is outside the postmaster.c? Can anyone give me any > > hint? > > > Where do I mark a breakpoint so that I can follow the creation of an > > index > > > to file index.c for example? > > > > You have to start up your psql or other client run "SELECT > > pg_backend_pid();" > > and attach to that process in the debugger. It sounds like you've > > connected to > > the postmaster which doesn't actually do any of the work, it just forks > > other > > backends. > > > > -- > > Gregory Stark > > EnterpriseDB http://www.enterprisedb.com > > > > > > -- > Pedro Belmino. > > # Ciência da Computação - UNIFOR > # [EMAIL PROTECTED] > > -- Pedro Belmino. # Ciência da Computação - UNIFOR # [EMAIL PROTECTED]
Re: [HACKERS] ECPG crash - upgrade from 8.0.3 to 8.1.10
On Thu, Oct 18, 2007 at 03:36:34PM -0400, Boergesson, Cheryl wrote: > Hello. I am trying to upgrade from PostgreSQL 8.0.3 to PostgreSQL > 8.1.10. I'm on WindowsXP and I'm compiling with Visual C++ 6.0. > ... > Oddly, when I removed all comments, it worked fine. Which comments? Michael -- Michael Meskes Email: Michael at Fam-Meskes dot De ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: [EMAIL PROTECTED] Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL! ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] Debugger
I am using linux. 1. Inicializei the postgres the console by running. / Postgres. 2. Joined in psql through console and simulated. / Psql 3. Pg_backend_pid swirled SELECT () to get the id of the process; 4. In ide tried to use that process to attach the debugger but gives the following error message: Unable to open file socket: target process not responding HotSpot VM or not loaded Thank, 2007/10/19, Gregory Stark <[EMAIL PROTECTED]>: > > > "Pedro Belmino" <[EMAIL PROTECTED]> writes: > > > Hellow, > > I continue to have problems using the debugger, can not achieve any > > breakpoint that is outside the postmaster.c? Can anyone give me any > hint? > > Where do I mark a breakpoint so that I can follow the creation of an > index > > to file index.c for example? > > You have to start up your psql or other client run "SELECT > pg_backend_pid();" > and attach to that process in the debugger. It sounds like you've > connected to > the postmaster which doesn't actually do any of the work, it just forks > other > backends. > > -- > Gregory Stark > EnterpriseDB http://www.enterprisedb.com > -- Pedro Belmino. # Ciência da Computação - UNIFOR # [EMAIL PROTECTED]
Re: [HACKERS] ts_rewrite aggregate API seems mighty ugly
Gregory Stark <[EMAIL PROTECTED]> writes: > "Tom Lane" <[EMAIL PROTECTED]> writes: >> True. I'll bet you don't like ts_stat() either. > It seems the right way interface here wouldn't be too different from what's > there. All we need is a SRF which takes a single tsvector and returns the set > of words from it. > Then you could do the aggregates yourself in SQL: > SELECT count(distinct apodid) as ndoc, >count(*) as nentry, >element > FROM ( > SELECT apodid, ts_elements(vector) AS element > FROM apod > ) GROUP BY element I'm not sure that's so much cleaner than what's there. It's relying on SRF-in-SELECT-list, which is doable at the C level but it's deprecated; plus the SRF has to return a record, which makes the notation a bit klugy --- (element).whatever in the upper select-list, and the GROUP BY probably won't work the way you show here, either. Another big problem is that the count(distinct) is going to cause the whole thing to have pretty awful performance. Not sure about a better way though... regards, tom lane ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [HACKERS] debugger
On Fri, Oct 19, 2007 at 08:23:43AM -0300, Pedro Belmino wrote: > Hellow, > I continue to have problems using the debugger, can not achieve any > breakpoint that is outside the postmaster.c? Can anyone give me any hint? > Where do I mark a breakpoint so that I can follow the creation of an index > to file index.c for example? > Thank, Are you correctly attaching the debugger to the child (and not just the postmaster). Have a nice day, -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate. signature.asc Description: Digital signature
Re: [HACKERS] Strange error dropping foreign key
Ühel kenal päeval, R, 2007-10-19 kell 15:29, kirjutas Magnus Hagander: > On Thu, Oct 18, 2007 at 10:48:02AM -0400, Tom Lane wrote: > > "Magnus Hagander" <[EMAIL PROTECTED]> writes: > > > db=# alter table isi.items_stat drop constraint items_stat_item_id_fkey; > > > ERROR: "items_pkey" is an index > > > > Context please? > > Yeah, I had that one coming, didn't it... That's what I get for trying to > type it up on my phone on the way home. > > Anyway. I've asked for a dump of the db to get all the details, but basically: > CREATE TABLE items ( >id int not null primary key, > > ); > CREATE TABLE items_stat ( >item_id int not null references items.id, > > ); > > > One thing that might be related - items is a Slony slave table. items_stat > is *not* in the Slony set. It's not *supposed* to have a foreign key to the > items table, which is why I'm trying to drop it. Slony does strange stuff to FK-s and other constraints, at least in 1.X versions (like changing the relation type from index to ) and thus you are not supposed to do DDL directly on slaves (or even masters). You should use EXECUTE SCRIPT slonik command to do DDL, so that drop index happens while original state is temporaryly restored) Actually this should belongs to Slony list ;) > It had the same scenario on teh primary slony node, but there the ALTER > TABLE to drop the constraint worked fine. Again, items is master in the > slony set, items_stat is not in any slony set. > > //Magnus > > ---(end of broadcast)--- > TIP 6: explain analyze is your friend ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] Strange error dropping foreign key
On Thu, Oct 18, 2007 at 10:48:02AM -0400, Tom Lane wrote: > "Magnus Hagander" <[EMAIL PROTECTED]> writes: > > db=# alter table isi.items_stat drop constraint items_stat_item_id_fkey; > > ERROR: "items_pkey" is an index > > Context please? Yeah, I had that one coming, didn't it... That's what I get for trying to type it up on my phone on the way home. Anyway. I've asked for a dump of the db to get all the details, but basically: CREATE TABLE items ( id int not null primary key, ); CREATE TABLE items_stat ( item_id int not null references items.id, ); One thing that might be related - items is a Slony slave table. items_stat is *not* in the Slony set. It's not *supposed* to have a foreign key to the items table, which is why I'm trying to drop it. It had the same scenario on teh primary slony node, but there the ALTER TABLE to drop the constraint worked fine. Again, items is master in the slony set, items_stat is not in any slony set. //Magnus ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] Debugger
"Pedro Belmino" <[EMAIL PROTECTED]> writes: > Hellow, > I continue to have problems using the debugger, can not achieve any > breakpoint that is outside the postmaster.c? Can anyone give me any hint? > Where do I mark a breakpoint so that I can follow the creation of an index > to file index.c for example? You have to start up your psql or other client run "SELECT pg_backend_pid();" and attach to that process in the debugger. It sounds like you've connected to the postmaster which doesn't actually do any of the work, it just forks other backends. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] max_prepared_transactions default ... why 5?
> >> Hmm, which locale do you use and what breakage do you see? > > > Swedish_Sweden.1252. Diffs attached. The reason is that in swedish sort > > order, "w" and "v" are considered equal. > > If that's all, I see no objection to adding a select_1.out expected > file that matches your results. > I've just assumed there are similar problems in other locales... If not I can just ad that... /Magnus ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] Debugger
PostgreSQL consists of multiple processes, launched by postmaster, make sure you are debugging the right one. After connecting to a database with your favorite client (i.e. psql) you can use ps (if you have a unix-like system) or a task manager to determine a pid of postgres process and then attach to that process with a debugger. Pedro Belmino wrote: > Hellow, > I continue to have problems using the debugger, can not achieve any > breakpoint that is outside the postmaster.c? Can anyone give me any hint? > Where do I mark a breakpoint so that I can follow the creation of an index > to file index.c for example? > Thank, > > -- > Pedro Belmino. > > # Ciência da Computação - UNIFOR > # [EMAIL PROTECTED] > -- Alexey Klyukin http://www.commandprompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] max_prepared_transactions default ... why 5?
Magnus Hagander <[EMAIL PROTECTED]> writes: > On Thu, Oct 18, 2007 at 10:45:29AM -0400, Tom Lane wrote: >> Hmm, which locale do you use and what breakage do you see? > Swedish_Sweden.1252. Diffs attached. The reason is that in swedish sort > order, "w" and "v" are considered equal. If that's all, I see no objection to adding a select_1.out expected file that matches your results. regards, tom lane ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Debugger
"Pedro Belmino" <[EMAIL PROTECTED]> writes: > I continue to have problems using the debugger, can not achieve any > breakpoint that is outside the postmaster.c? Can anyone give me any hint? > Where do I mark a breakpoint so that I can follow the creation of an index > to file index.c for example? Sounds to me like you attached the debugger to the wrong process. Start a session, find out the backend's PID, then attach to that. regards, tom lane ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Plan invalidation vs temp sequences
Gregory Stark wrote:
"Tom Lane" <[EMAIL PROTECTED]> writes:
There doesn't seem to be any very nice way to fix this. There is
not any existing support mechanism (comparable to query_tree_walker)
for scanning whole plan trees, which means that searching a cached plan
for regclass Consts is going to involve a chunk of new code no matter
how we approach it. We might want to do that someday --- in particular,
if we ever try to extend the plan inval mechanism to react to
redefinitions of non-table objects, we'd likely need some such thing
anyway. I'm disinclined to try to do it for 8.3 though. The use-case
for temp sequences seems a bit narrow and there are several workarounds
(see followups to bug report), so I'm feeling this is a
fix-some-other-day kind of issue.
Given that sequences are in fact relations is there some way to work around
the issue at least in this case by stuffing the sequence's relid someplace
which the plan invalldation code can check for it?
Hm... couldn't this be worked around by doing
create or replace function dynamic_oid(text) returning regclass as
'select $1::regclass' language 'pl/pgsql' stable;
And then writing
nextval(dynamic_oid('mysequence')).
I didn't test this, but it it actually works, maybe we should just stick this
into the docs somewhere. It's probably too late to add that function to the
backend, though...
As long as mysequence is really a temporary sequence, this wont even have
searchpath issues I think, because those are always on top of the searchpatch
anyway, aren't they?
greetings, Florian Pflug
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] full text search in 8.3
Andy,
seems you're a right person for writing migration guide.
Oleg
On Wed, 10 Oct 2007, andy wrote:
andy wrote:
Andy Colson wrote:
Hi All,
You knew it was coming
I tried doing a pg_dump --schema-only and restoring just that, but still
got a bunch of errors (those above). If I clean that up of all the old
text search stuff, and then run it, then do the data, will that work ok?
Further to this, I edited the schema, and created it ok, then dumped the
data across (after editing out all the tsearch stuff). So far so good.
However, my trigger failed:
CREATE TRIGGER fulltext_update
BEFORE INSERT OR UPDATE ON times
FOR EACH ROW
EXECUTE PROCEDURE tsearch2('vectors', 'remarks');
Looks like we renamed/removed the tsearch2 function? Is
setweight(to_tsvector()) the new way?
-Andy
Ah, found it.. in the doc's no less :-)
CREATE TRIGGER tsvectorupdate BEFORE INSERT OR UPDATE
ON tblMessages FOR EACH ROW EXECUTE PROCEDURE
tsvector_update_trigger(tsv, 'pg_catalog.english', strMessage);
-Andy
---(end of broadcast)---
TIP 6: explain analyze is your friend
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] Skytools committed without hackers discussion/review
On 10/10/07, Marko Kreen <[EMAIL PROTECTED]> wrote: > On 10/10/07, Tom Lane <[EMAIL PROTECTED]> wrote: > > * Why is txid_current_snapshot() excluding subtransaction XIDs? That > > might be all right for the current uses in Slony/Skytools, but it seems > > darn close to a bug for any other use. > > In queue usage the transaction that stores snapshots does not do > any other work on its own, so it does not matter, main requirement > is that txid_current()/txid_current_snapshot() be symmetric - > whatever the txid_current() outputs, the txid_current_snapshot() measures. > > But I agree, supporting subtransactions makes the API more > universal. And it wouldn't break Slony/PgQ current usage. I thought about it with a clear head, and am now on optinion that the subtransactions should be left out from current API. I really fail to imagine a scenario where it would be useful. The module main use comes from the scenario where txid_current(), txid_current_snapshot() and reader of them are all different transactions. Main guarantee that the APi makes is that as soon you can see a inserted snapshot in table, you can also see all inserted events in different table. There does not seem to be any use of them intra-transaction. Adding them currently in would be just premature bloat. We can do it always later, when someone presents a case for them. Then we can also decide whether it should be added to current API or have parallel API besides. It should not break Slony/Skytools either way. -- marko ---(end of broadcast)--- TIP 6: explain analyze is your friend ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] full text search in 8.3
Oleg Bartunov wrote: Andy, seems you're a right person for writing migration guide. Oleg On Wed, 10 Oct 2007, andy wrote: Where would be an easy place to find all the renamed functions? My experience with fts is limited to one project, and I just used all the default dictionaries, so I've never even played with any of that. That being said, I'd be happy to write up what I can (and I can try to put together a list of the renamed functions). Is there any chance there is an easier way to backup/restore? On one hand, its not too bad, and it'll only be once (correct?). Now that fts is in core future backup/restores will work, right? I think it's analogous to telling someone they are updating from tsearch2 to tsearch3, and it might be a little more painful than just a backup/restore. On the other hand I think a backup/restore will pollute the new db with a bunch of functions and types that wont ever be used, so it's so much cleaner to build it by hand. Are there other fts users that might have opinions on that? -Andy ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[HACKERS] Debugger
Hellow, I continue to have problems using the debugger, can not achieve any breakpoint that is outside the postmaster.c? Can anyone give me any hint? Where do I mark a breakpoint so that I can follow the creation of an index to file index.c for example? Thank, -- Pedro Belmino. # Ciência da Computação - UNIFOR # [EMAIL PROTECTED]
[HACKERS] debugger
Hellow, I continue to have problems using the debugger, can not achieve any breakpoint that is outside the postmaster.c? Can anyone give me any hint? Where do I mark a breakpoint so that I can follow the creation of an index to file index.c for example? Thank, -- Pedro Belmino. # Ciência da Computação - UNIFOR # [EMAIL PROTECTED]
Re: [HACKERS] full text search in 8.3
andy wrote: Is there any chance there is an easier way to backup/restore? On one hand, its not too bad, and it'll only be once (correct?). Now that fts is in core future backup/restores will work, right? I think it's analogous to telling someone they are updating from tsearch2 to tsearch3, and it might be a little more painful than just a backup/restore. On the other hand I think a backup/restore will pollute the new db with a bunch of functions and types that wont ever be used, so it's so much cleaner to build it by hand. Are there other fts users that might have opinions on that? I'm not really a tsearch user (just played with it a bit once). But I wondered if you are aware that you can prevent certain objects from being restored quite easiy if you use pg_dump and pg_restore together with "custom format" (-Fc). There is some option to pg_restore that reads the dump, and ouputs a table of contents. You can then remove some entries from that list, and pass the modified list to pg_restore which will skip entries that do not show up on your modified list. Maybe we could document some regexp, awk script, or similar that strips the tsearch stuff from such a table of contents? regards, Florian Pflug ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] max_prepared_transactions default ... why 5?
On Thu, Oct 18, 2007 at 10:45:29AM -0400, Tom Lane wrote: > "Magnus Hagander" <[EMAIL PROTECTED]> writes: > > Bummer. There are lots of ways to break installcheck though - locale > > being one I get biten by all the time... > > Hmm, which locale do you use and what breakage do you see? Swedish_Sweden.1252. Diffs attached. The reason is that in swedish sort order, "w" and "v" are considered equal. //Magnus *** ./expected/select.out 2007-07-11 10:53:23.478371800 +0200 --- ./results/select.out2007-10-19 09:22:33.042274100 +0200 *** *** 391,398 chris | 78 sharon | 78 susan | 78 - vera| 78 wendy | 78 julie | 68 leah| 68 paula | 68 --- 391,398 chris | 78 sharon | 78 susan | 78 wendy | 78 + vera| 78 julie | 68 leah| 68 paula | 68 == ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
