[HACKERS] UNIQUE not unique with inheritance (workaround?)
Is there any workaround for this problem? I'm getting involved in a project where inheritance is an incredibly useful feature, but the non-unique issue could be a serious stumbling block. Is there any way to work around it with a trigger or something? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [HACKERS] Performance monitor signal handler
On Sat, Mar 17, 2001 at 09:33:03AM -0500, Jan Wieck wrote: > > The general problem remains. We only have one central > collector with a limited receive capacity. The more load is > on the machine, the smaller it's capacity gets. The more > complex the DB schemas get and the more load is on the > system, the more interesting accurate statistics get. Both > factors are contraproductive. More complex schema means more > tables and thus bigger messages. More load means more > messages. Having good statistics on a toy system while they > get worse for a web backend server that's really under > pressure is braindead from the start. > Just as another suggestion, what about sending the data to a different computer, so instead of tying up the database server with processing the statistics, you have another computer that has some free time to do the processing. Some drawbacks are that you can't automatically start/restart it from the postmaster and it will put a little more load on the network, but it seems to mostly solve the issues of blocked pipes and using too much cpu time on the database server. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] How to shoot yourself in the foot: kill -9 postmaster
On Tue, Mar 06, 2001 at 12:46:24PM -0800, Nathan Myers wrote: > > On Linux, /usr/src/linux/include is meaningless for anything in userland; > it's meant only for building the kernel and kernel modules. That Red Hat > tends to expose it to user-level builds is a long-standing bug in Red > Hat's distribution, in violation of the File Hierarchy Standard as well > as explicit instructions from Linus & crew and from the maintainer of the > C library. > Red Hat's Fisher Beta has split the 2 includes, which caused an error trying to compile a (I guess badly configured) kernel module. The header files in /usr/include now give an error if you try to build a kernel module that gets header files from there. So whether they were wrong in the past or not, they are now doing things the way you say is proper. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] COPY BINARY is broken...
On Fri, Dec 01, 2000 at 05:56:57PM -0500, Tom Lane wrote: > Alfred Perlstein <[EMAIL PROTECTED]> writes: > > I would rip it out. > > I thought about that too, but was afraid to suggest it ;-) > > How many people are actually using COPY BINARY? > I have used it, I don't think I'm actually using right now. But, it was very handy. (Once I finally figured out the format through trial and error, ouch!) It is very nice to be able to just dump tuples in, instead of having to format them to text, then the database has to put them back to binary again. So, an alternative with a clean interface would be very much appreciated.