[GENERAL] How do I implement a .XSD in Postgres?

Hi everybody, I need to import some DB schemas which are defined in .XSD (a XML derivative) format. I've googled about this but have found no satisfactory answer. Perhaps I just don't know what exactly to ask Google. So please: - What tool can I use in order to import .XSD schema definitions into

[GENERAL] Question on Trigram GIST indexes

@Moderators: I am reposting this because the original from 22 December apparently didn't arrive on the list. I was trying to make Postgresql use a trigram gist index on a varchar field, but to no avail. Specifically, I was trying to replicate what is done in this blog post: http://www.postgresonl

Re: Fwd: [GENERAL] Question on Trigram GIST indexes

in RAM. I wonder what it that the other gentleman, Merlin, found out in the documentation and if he would share that. I've also tried this on another table I have, with and without other indexes, but no success :-( Wondering ... On 23 January 2013 04:05, Tom Lane wrote: > ERR ORR writes:

Re: [GENERAL]

- Is your postgres server actually up and running? - Did you add localhost to the addresses served by postgres in pg_hba.conf (with proper permissions)? - Have you considered upgrading your postgres installation to a current version? 8.0.0-rc1 is WAY obsolete. On 23 March 2013 15:13, News Subsyst

[GENERAL] Question re contribs of Julian Assange

I noticed on the postgresql website that a certain *Julian Assange* is mentioned among the contributors to Postgresql. Out of curiosity, could anybody post in short what exactly he contributed to the DB? Thanks, RD

[GENERAL] Upgraded to 9.3

This is just to say that I upgraded from V9.2.6 to V9.3.2. Same HW, same data, an astonishing performance increase. Postgres is flying [?] Thanks lots and *Merry Christmas* and a *Happy New Year* to you all!!! [?][?][?][?] RD <<03D.gif>><><><<333.png>><>

Re: [GENERAL] Table with million rows - and PostgreSQL 9.1 is not using the index

Hi Edson, since you are using 'like' in your select, you may want to try the following (example): CREATE INDEX "MY_LONG_INDEX_NAME_IDX" ON "MY_TABLE_NAME" USING btree ("MY_VARCHAR_FIELD_NAME" COLLATE pg_catalog."default" *varchar_pattern_ops *); (for TEXT fields, use *text_pattern_ops* in t

[GENERAL] Question about indexes and operator classes

Hi, I actually have several questions on indexes and operator classes: 1) What is the difference between *varchar_pattern_ops* and * varchar_text_ops*? They both appear to work similarly and in both cases the operands are cast to type TEXT when I look at the explain of the query. 2) Is there any

[GENERAL] Question on Trigram GIST indexes

I was trying to make Postgresql use a trigram gist index on a varchar field, but to no avail. Specifically, I was trying to replicate what is done in this blog post: http://www.postgresonline.com/journal/archives/212-PostgreSQL-9.1-Trigrams-teaching-LIKE-and-ILIKE-new-tricks.html I use Postgresq

Fwd: [GENERAL] Question on Trigram GIST indexes

(forwarded to pgsql-general after it went to Kevin Grittner alone) On 22 December 2012 22:46, Kevin Grittner wrote: > ERR ORR wrote: > > > Specifically, I was trying to replicate what is done in this blog post: > > > http://www.postgresonline.com/journal/archives/212-Po