| From: | Jonathan Bartlett <johnnyb(at)eskimo(dot)com> |
|---|---|
| To: | Vivek Khera <khera(at)kcilink(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Humor me: Postgresql vs. MySql (esp. licensing) |
| Date: | 2003-10-10 06:09:30 |
| Message-ID: | Pine.GSU.4.44.0310092309090.621-100000@eskimo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> I think it is a timing issue. The PG has no way to notify the OS that
> it has finished exiting, so if it takes a long time to exit, the OS
> will ungracefully kill the DB process(es). Doesn't matter what DB (or
> any other application) you're running, you *can* lose data this way.
No, writet-ahead logs prevent problems in this way.
Jon
>
> --
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Vivek Khera, Ph.D. Khera Communications, Inc.
> Internet: khera(at)kciLink(dot)com Rockville, MD +1-240-453-8497
> AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marek Lewczuk | 2003-10-10 07:53:11 | Re: SQL query problem (many table in FROM statement and many LEFT JOIN's) |
| Previous Message | Stuart Barbee | 2003-10-10 03:51:24 | Re: SQL query problem |