I am little bit confused between whether to insert XML file as it is or insert data from the XML file in to a particular field from the table.
I will decided it depending upon the performance factor
For storing the XML file as it is, will there be any performance cause if compared to storing va
-Tyan dual-core/dual-cpu mainboard (
-One Opteron 270 2.0GHz (although our vendor gave us two for some reason)
-Chenbro 3U case (RM31212B) - OK, but not very well thought-out
-8 Seagate SATA drives (yes, we stuck with our vendor of choice, WD
Raptors may have been a better choice)
-3Ware 9550SX-12
Without having looked at this in detail my first suggestion would be to
do away with those date_part indices. I have found that indexes with few
distinct values usually hurt more then help and the PG optimizer is not
always smart enough to ignore them and the BitmapAnd and scan for dates
seem like
George Pavlov wrote:
> Based on how it works it seems that a server crash might lose the
> in-memory stats data as well?
Yeah, IIRC the postmaster removes the stat file after crash recovery.
It doesn't check the file for correctness.
> I imagine PITR does not take care of that special file (wher
> These stats are not stored in tables, only in memory and saved to a
> special file on disk to be able to preserve it across server
> stop/start.
> But pg_dump does not make the slightest attempt to save it.
>
> Also, you can't save it yourself -- while you could save the values it
> returns on
> On Fri, 2006-08-25 at 21:23 +0530, soni de wrote:
> > Hello,
> >
> > I want to ask, Is there any way to insert records from XML
> > file to the postgres database?
>
> Try the contrib/xml2 module.
Alas, that module will not help you much with the insertion of records.
It is more about queryin
